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.
Solved! Go to Solution.
Solved by kovyljan. Go to Solution.
Solved by FAIR59. Go to Solution.
Solved by David_W_Koch. Go to 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.
Awesome, Understood the logic behind the formula and I got the desired output. Thank you!
lookup table. More limitless possibilities
ОТВЕЧАЕМ НА ВАШИ ВОПРОСЫ НА ФОРУМЕ BIM2B
Can't find what you're looking for? Ask the community or share your knowledge.