AnsweredAssumed Answered

How do you nest an if Equation.

Question asked by Josh Atkionson on Sep 2, 2014
Latest reply on Sep 2, 2014 by Josh Brady

How do you nest an if Equation for Example will this work =if(overall height<=2500,2 if(overall height<=3500,3,4)) basically i am looking the answer to come out as if the height is less than 2500mm the ANS=2 if it is less than 3500mm but Greater than 2500mm the ANS=3 and then for any Height Greater than 3500mm the ANS=4. Please Help or is there any other Way of getting the some outcome Thanks.