Excel Formula Help
 

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.

Excel Formula Help
 

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


"Mark Solesbury" wrote:

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.