Formula Question

Giganews Newsgroups
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

Replies