"if and" and greater than or equal to

D.wilson ✭✭
edited 02/03/23 in Formulas and Functions

Can anyone help me figure out why this formula is returning an #invalid operation result? It seems to get angry whenever I put the "=" into the "less than or equals" part of the and functions...

=IF([TOTAL Risk score]@row <= 20, 0, IF(AND([TOTAL Risk score]@row > 20, [TOTAL Risk score]@row <= 50), 0.25, IF(AND([TOTAL Risk score]@row > 50, [TOTAL Risk score]@row < =70), 0.5, IF(AND([TOTAL Risk score]@row > 70, [TOTAL Risk score]@row <= 90), 0.75, 1))))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!