topic Re: IF/AND Statement using visibility in Revit Architecture Forum

IF/AND Statement using visibility

dwackerX6C3B — Wed, 29 Jan 2025 13:08:57 GMT

Good morning,

What I'm trying to achieve is an IF ( AND visibility statement, outlined below:

X = IF ( AND (UCAL3300 = 1, Dept < 28"), 2 , 1 )

"UCAL3300" is a simple Yes/No visibility toggle

My goal is for "X" to always show when "UCAL3300" is toggled off and when "UCAL3300 is toggled on but the depth is greater than 28".

Appreciate the help.

Re: IF/AND Statement using visibility

David_W_Koch — Wed, 29 Jan 2025 14:09:52 GMT

Assuming that X is a Yes/No parameter, the following will do what you describe:

if(not(UCAL3300), 1 = 1, if(and(UCAL3300, not(Depth > 2' 4")), 1 = 1, 1 = 0))

If you want X to be 2 when it is "on" and 1 when it is "off", then replace 1=1 with 2 (twice) and 1=0 with 1.

When UCAL3300 is unchecked, X is checked, regardless of whether Depth is less than, equal to, or greater than 2'-4".

When UCAL3300 is checked, X is checked, when Depth is less than or equal to 2'-4", but is unchecked when Depth is greater than 2'-4".

Re: IF/AND Statement using visibility

David_W_Koch — Wed, 29 Jan 2025 14:13:54 GMT

It occurs to me that the formula can be simplified. The first if tests for whether UCAL3300 is checked or not, so there is no need to test it again. Use this instead:

if(not(UCAL3300), 1 = 1, if(not(Depth > 2' 4"), 1 = 1, 1 = 0))

It gives the same results.

Re: IF/AND Statement using visibility

RDAOU — Wed, 29 Jan 2025 14:36:31 GMT

@dwackerX6C3B

How about this? Instead of nested IFs Combine the conditions for when it is on using OR/NOT/AND together in one IF

If(or(not(UCAL3300), and(UCAL3300 , Dept > 28”)), 2>1,2<1)

If(or(not(UCAL3300), and(UCAL3300 , Dept > 28”)),2>1,2<1)