I need a formula that will give me an IF, THEN answer. This is what I need:
If the value in A1 is less than 1.99, then the number 0 would be in A2, If
the value in A1 is between 2 and 4.99, then .5 would be in A2, If the value
in A1 is greater than 5 then the number 1 would be in A2.