Paramater driven value
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 |
Paramater driven value
=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 |
Paramater driven value
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 |
All times are GMT +1. The time now is 02:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com