topic Re: Is it possible to write an IF/THEN formula for this situation? in Revit Architecture Forum

Is it possible to write an IF/THEN formula for this situation?

Sahay_R — Wed, 18 Dec 2019 17:03:21 GMT

Hell Revit Community,

I am attempting to write a formula that looks at ranges of values instead of a single value -

IF parameter A is 4"-21", THEN parameter A1 = 3"

IF parameter B - 21.5"-23", THEN parameter B1 = 4"

IF parameter C = 21.5"-25", THEN parameter C1 = 5"

Thank you!

Rina

Re: Is it possible to write an IF/THEN formula for this situation?

barthbradley — Wed, 18 Dec 2019 17:19:13 GMT

you mean: A1 =if (and(A > 0' 4", A < 1' 9"), 0' 3", 0')?

What's A1 if False? 0"?

Re: Is it possible to write an IF/THEN formula for this situation?

martijn_pater — Wed, 18 Dec 2019 17:18:46 GMT

hmmm I'm thinking maybe something like...
A1 --> formula : IF ( AND (A >4" , A< 21"), 3", <else>)

B1 --> formula : IF ( AND (B>21.5" , A< 23"), 4", <else>)

C1 --> formula : IF ( AND (C >21.5" , A<25"), 5", <else>)

or perhaps something for lookup table?

Re: Is it possible to write an IF/THEN formula for this situation?

barthbradley — Wed, 18 Dec 2019 17:39:07 GMT

Seriously @Sahay_R ???

Re: Is it possible to write an IF/THEN formula for this situation?

Sahay_R — Wed, 18 Dec 2019 17:40:51 GMT

What about this

IF parameter A is 4"-21", THEN parameter A1 = 3"

IF parameter A - 21.5"-23", THEN parameter A2 = 4"

IF parameter A = 21.5"-25", THEN parameter A3 = 5"

Re: Is it possible to write an IF/THEN formula for this situation?

Sahay_R — Wed, 18 Dec 2019 17:43:31 GMT

Re: Is it possible to write an IF/THEN formula for this situation?

ToanDN — Thu, 19 Dec 2019 02:24:16 GMT

@Sahay_R wrote:

What about this

IF parameter A is 4"-21", THEN parameter A1 = 3"

IF parameter A - 21.5"-23", THEN parameter A2 = 4"

IF parameter A = 21.5"-25", THEN parameter A3 = 5"

Are you sure about those? What if A is out-of-range?

Re: Is it possible to write an IF/THEN formula for this situation?

RDAOU — Thu, 19 Dec 2019 14:44:22 GMT

Something odd about those formulas...are all those parameters in 1 project? if they are, and Parameter A (which I suppose has a unique value) is driving 3 different parameters A1, A2 and A3, what happens to A2 and A3 when the first condition/if statement is satisficed? same when the second and 3rd IFs are satified!

Nest the If/Then statements is such case would be more logical … I think

Re: Is it possible to write an IF/THEN formula for this situation?

Sahay_R — Fri, 20 Dec 2019 18:40:24 GMT

Sorry about that, @ToanDN - I clacked when I should have clicked!

You are right - it should have been

IF parameter A is 4"-21", THEN parameter A1 = 3"

IF parameter A - 21.5"-23", THEN parameter A2 = 4"

IF parameter A = 23.5"-25", THEN parameter A3 = 5"

Re: Is it possible to write an IF/THEN formula for this situation?

martijn_pater — Sun, 22 Dec 2019 12:06:21 GMT

Just a few comments/questions:) First you are not really writing down ranges [x,y] mathematically here, second you haven't provided a definition of <else> for A1/A2/A3 if your condition in your if statement returns false ie. if it falls outside of this range, third is that parameters A1/A2/A3 can test for the same condition and return values accordingly... Perhaps you could elaborate on what you were trying to make here.

As you've written it down (is/-/=), it's something like A1=3" if A=-17", A2=4" if A is a rational number (lenght/number?)/always true?, A3=5" if A=-1.5" 🙂 So I'm going to assume that's not what you meant. ^^ But actually if you want to include 4" and 21" in your specified range [4",21"] = 4"≤A≤21" your formula/conditional statement should look like:
A1 with formula; if(and(not(A < 4"), not(A > 21")), 3", 0")
A2 with formula; if(and(not(A < 21.5"), not(A > 23")), 4", 0")
A3 with formula; if(and(not(A < 23.5"), not(A > 25")), 5", 0")

The formula's posted earlier actually represents the range as (4",21") instead of [4",21"]. Since you haven't specified values for A1/2/3 if A falls outside of these ranges, like barthbradley I've set all of them to 0... But possibly you need it to be something else, that remains unclear...