How do I create a function to give a value to a calculation

Example:

Total number of errors 3
Number of clients signed 3
% errors to clients signed 100%

If the error rate is 0% the formula should calculate 100%
If the error rate is 0%<21% calculation should be 80%
If the error rate is 20%<41% calculation should be 60%
If the error rate is 40%<61% calculation should be 40%
If the error rate is 60%<80% calculation should be 20%
If the error rate is =/80% calculation should be 0%

I have tried IF but just get errors (still learing all these formulas)
--
Andrew

=VLOOKUP(error_rate,{0,1;0.001,0.8;0.2,0.6;0.4,0.4 ;0.6,0.2;0.8,0},2,TRUE)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Andrew" wrote in message
...
How do I create a function to give a value to a calculation

Example:

Total number of errors 3
Number of clients signed 3
% errors to clients signed 100%

If the error rate is 0% the formula should calculate 100%
If the error rate is 0%<21% calculation should be 80%
If the error rate is 20%<41% calculation should be 60%
If the error rate is 40%<61% calculation should be 40%
If the error rate is 60%<80% calculation should be 20%
If the error rate is =/80% calculation should be 0%

I have tried IF but just get errors (still learing all these formulas)
--
Andrew

Thanks Bob!
--
Andrew


"Bob Phillips" wrote:

=VLOOKUP(error_rate,{0,1;0.001,0.8;0.2,0.6;0.4,0.4 ;0.6,0.2;0.8,0},2,TRUE)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Andrew" wrote in message
...
How do I create a function to give a value to a calculation

Example:

Total number of errors 3
Number of clients signed 3
% errors to clients signed 100%

If the error rate is 0% the formula should calculate 100%
If the error rate is 0%<21% calculation should be 80%
If the error rate is 20%<41% calculation should be 60%
If the error rate is 40%<61% calculation should be 40%
If the error rate is 60%<80% calculation should be 20%
If the error rate is =/80% calculation should be 0%

I have tried IF but just get errors (still learing all these formulas)
--
Andrew