steverpi75
New Member
- Joined
- Mar 23, 2006
- Messages
- 14
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.
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.