"if and" and greater than or equal to

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

Mike TV

@D.wilson

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

Mike TV

@D.wilson

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

Mike TV

@D.wilson

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

Mike TV

@D.wilson

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

D.wilson

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