1 of 1 people found this helpful
Since it is a percentage you should use decimals in your calculation formula:
Value is between .9 and 1
Value is between .79 and .9
Value is < .8
Also there is some overlap in your values.
Thanks--I had tried decimals but because of the overlap problem it didn't work correctly.