Formula Question:create a nested If statement

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

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



"metaltecks" <metaltecks@discussions.microsoft.com> wrote in message
news:EA16B28E-522D-4A5A-9875-C781BF48F659@microsoft.com...
>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