- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- Formula Question

Subject: | Formula Question |

Posted by: | metaltecks |

Date: | Thu, 4 May 2006 |

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

- Re: Formula Question posted by Peo Sjoblom on Thu, 4 May 2006