Question

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

Mike TV · Accepted Answer

@D.wilson

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

Mike TV · Accepted Answer

@D.wilson

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