REVIT MULTIPLE IF CONDITIONS WITH 4 PARAMETERS

[Anonymous]

Hi Everyone, 

I wanted to create a formula with 4 parameters and it reflects back in Text Parameter.

For Example,

If A is Checked it should display "A";

If B is Checked it should display "B";

If both A and B are Checked it should display "Select any One"

If both A and B are unChecked it should display "No Text". 

For two parameters I wrote the formula but I wanted this to be achieved with A, B, C, D.

Any help or suggestions will be appreciated.

Thanks in advance.

[David_W_Koch · Accepted solution]

This should work for you:

if(or(and(A, B), and(A, C), and(A, D), and(B, C), and(B, D), and(C, D)), "SELECT ANY ONE", if(A, "A", if(B, "B", if(C, "C", if(D, "D", "NO TEXT")))))

The first if conditional tests all possible combinations of two of the four parameters to see if both are true, and combines those in a "or".  This will evaluate to True if any two or more of the four parameters are checked, and it returns "SELECT ANY ONE".

The only possibilities left are only one of the parameters is checked, or none are.  The else of the first conditional test is an if statement, testing to see if A is checked, if so, it returns "A", if not, another if tests if B is checked, if so, it returns "B", and so on for both C and D.  If the logical flow gets to the final else, then none are checked, so "NO TEXT" is returned.

[FAIR59 · Accepted solution]

Formula's easy to expand for multiple conditions:

parameter [ Checked_Count ] is an integer parameter

[Anonymous]

Awesome, Understood the logic behind the formula and I got the desired output. Thank you!

[Anonymous]

Thank you so much! I wonder this can be achieved through this method as well! Definitely a helpful method! 

[kovyljan · Accepted solution]

lookup table. More limitless possibilities