# "if and" and greater than or equal to

Options
✭✭
edited 02/03/23

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))))

• ✭✭✭✭✭✭
Options

Are you putting a space between the < and the =? You can't do that.

• ✭✭✭✭✭✭
Options

It looks like this is the part with the space that's messing it up: [TOTAL Risk score]@row < =70)

• ✭✭✭✭✭✭
Options

Are you putting a space between the < and the =? You can't do that.

• ✭✭✭✭✭✭
Options

It looks like this is the part with the space that's messing it up: [TOTAL Risk score]@row < =70)

• ✭✭
Options

Ah hah! You're right! There was one stray extra space in there. THANK YOU!!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!