IF/AND Statement using visibility

[dwackerX6C3B]

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.

[David_W_Koch · Accepted solution]

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".

[David_W_Koch]

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. 

[RDAOU]

@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)