Conditional Boolean Expression Difficulty

Conditional Boolean Expression Difficulty

mcobb
Advocate Advocate
753 Views
3 Replies
Message 1 of 4

Conditional Boolean Expression Difficulty

mcobb
Advocate
Advocate

Can someone tell me what I am doing wrong with this expression?:

 

IF(AND(Muntins Interior Visibility,Muntins Exterior Visibility),yes,no)

 

Muntin Interior Visibility and Muntin Exteror Visibility are both yes/no variables. I want another single variable to return a "yes" value when the two other values (Muntins Interior Visibility and Muntins Exterior Visibility) are "yes".

 

Any help is greatly appreciated.

Regards,

Mike
0 Likes
Accepted solutions (1)
754 Views
3 Replies
Replies (3)
Message 2 of 4

ToanDN
Consultant
Consultant
Accepted solution

AND (Muntins Interior Visibility, Muntins Exterior Visibility)

0 Likes
Message 3 of 4

mcobb
Advocate
Advocate

I thought I tried that, but clearly, I didn't because it worked this time! Thanks so much for your continued help.

Regards,

Mike
0 Likes
Message 4 of 4

mhiserZFHXS
Advisor
Advisor

Yea, you don't need "IFs" for yes/no parameter formulas. Its implied since there are only two possible options.

0 Likes