Excel Formula Help

[Mark Solesbury]

Hello

Ive got some 'scores' to put into excel. For each score, a set number of
points is awarded.

Score - 0-5 - No Points
6-9 - 12 points
10-11 - 20 points
12+ - 25 Points

Ive been trying to get a formula to calculate the points and enter it in
a different cell.

Any Help?

Mark.

 

[Guest]

Let's say your score is in cell A1, use this formula in the cell where you
want the points to appear:

=IF(A1<=5,0,IF(A1<=9,12,IF(A1<=11,20,25)))

HTH,
Elkar