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.

Hi Josh,

I would use an IIF function for that

This works for me :

if H > 2500 ANS get 2 else we enter another iif which gives 4 if H > 3500, else it gives 3

Have fun with SolidWorks!

Eddy