IF logical test, value if true, value if false

[steverpi75]

I'm having a hard time writing an equation for this scenario:

For an error rate:

0.0 to 0.3 = 0.02 points

>0.3 to 0.6 = linear slope between .3 and .6

>0.6 = 0.0 points

This is the equation im using:

=IF(O3<=S3,0.02,IF(O3>S3,(R3-O3)/15,"0.00"))

Where:
O3= error rate value that I'm trying to score
S3=0.3
R3=0.6

The equation works until I have a number > 0.6 at which point I get negative numbers, which I don't want.

Thanks for the help.

 

[Oaktree]

Try this:

=IF(O3<=S3,0.02,IF(O3<R3,(R3-O3)/15,0))

Note that using "0.00" returns a text value. If that's what you want, then replace the ,0 at the end to ,"0.00" as before.