IF Condition issue

Finops C'ship
Finops C'ship ✭✭
edited 05/27/21 in Formulas and Functions

Hi,


Can someone help me why i am just getting the value as Quarter if i change the value to less than 25 in column

=IF([1.1 Landscape]1 > 0.0025, "Quarter", IF([1.1 Landscape]1 > 0.005, "Half", IF([1.1 Landscape]1 > 0.0075, "Three Quarter", IF([1.1 Landscape]1 > 0.001, "Full", "Empty"))))


THanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!