IF AND BETWEEN

[cjharley1450642179]

Hi all

I am trying to create a yes/no visibility statement to automatically show an Emergency Egress Window symbol

(if (OPENING LHS HOR CLEAR>450) AND (FIXED BOTTOM GLASS HEIGHT "is equal to or between" 800 & 1100))

If the above condition is met show

Emergency Egress Window symbol otherwise don't show.

I am using 2018

All help would be greatly appreciated

[dkoch]

Use this for your formula:

and(OPENING LHS HOR CLEAR > 450 mm, not(FIXED BOTTOM GLASS HEIGHT < 800 mm), not(FIXED BOTTOM GLASS HEIGHT > 1100 mm))

A Yes/No parameter does not need an if statement; just the logical test. If the logical test is TRUE, then the parameter will evaluate to Yes (checked); otherwise, it will evaluate to No (unchecked).

Revit does not support the greater than or equal to (X >= Y) or less than or equal to (X <= Y) logical operators. To get the equivalent, you have to use NOT(X < Y) or NOT(X > Y), respectively.

In the formula above, the AND statement requires all comparisons listed to be TRUE for the AND to be TRUE. So if the horizontal clear opening is greater than 450, the height to the bottom of the glass is not less than 800 and the height to the bottom of the glass in not greater than 1100, then the AND will be TRUE. Otherwise, the AND will be FALSE.