Formula Question

[Guest]

I have a worksheet that has a formulat I'm having problems figuring out.

A player is given a score, and based on the scores, and increase is given.
The ranges and increases arer:
280-308 2.5%
309-334 3%
337-364 3.5%
365-392 4%
393-419 4.5%

I want to create a formulat that will state if a score of 281 is given, the
increase will be 2.5, or if a score of 418 is given, the increase will be
4.5. I know I have to create a nested If statement, but I don't know how to
do it.

Help...thank you

 

[Peo Sjoblom]

One way, with your score in A1

=IF(A1="","",LOOKUP(A1,{0;280;309;337;365;393},{0;0.025;0.03;0.035;0.04;0.045}))


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com