Solved! Go to Solution.
Solved by CoreyDaun. Go to Solution.
michaelmead wrote:
"Can you do while loops in revit? If not, how do you track three variables? For example If 10<20, and 20<30, then C=1. the only problem is that C can have 4 values and logically can have more than one correct value based on the values of A and B...? any programers out there? Thanks!"
A while loop is not possible within Revit's... less than stellar formulaic abilities. You can use a series of nested IF/THEN/ELSE statements. For example, this formula defines the Integer Value of "ParamC" based on the values of "ParamA" and "ParamB":
if(and(ParamA>20, ParamB>20), 35, if(and(ParamA<20, ParamB>20), 25, if(and(ParamA<20, ParamB<20), 15, 5)))
This formula checks the conditions and returns the results as listed below:
IF AND... THEN…
"ParamA" "ParamB" "ParamC"=
>20 >20 35
<20 >20 25
<20 <20 15
None of the above 5
Hope that helps!