2 Replies Latest reply on Sep 2, 2014 9:11 AM by Josh Brady

    How do you nest an if Equation.

    Josh Atkionson

      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.