# "if and" and greater than or equal to

Options

D.wilson
✭✭

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

## Answers

## Help Article Resources

#### Categories

Want to practice working with formulas directly in Smartsheet?

Check out the

Check out the

**Formula Handbook template!**