Excel Formula Help take 2

  • Thread starter Thread starter Mark Solesbury
  • Start date Start date
M

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.
 
another option via LOOKUP:

=LOOKUP(C1,A1:A4,B1:B4)

=LOOKUP(C1,{0,6,10,12},{"No",12,20,25})&" Points"

--
KL
[MVP - Microsoft Excel]
RU: http://www.mvps.ru/Program/Default.aspx
ES: http://mvp.support.microsoft.com/?LN=es-es
EN: http://mvp.support.microsoft.com/?LN=en-us
Profile: https://mvp.support.microsoft.com/profile=AB32F8EE-8ED3-4AB9-ADDA-9E6C73C09A36


KL said:
Range [A1:B4]:
0 No Points
6 12 Points
10 20 Points
12 25 Points

Range [C1]:
your actual score

Formula:
=VLOOKUP(C1,A1:B4,2)

or without additional tables:

Formula:
=INDEX({"No",12,20,25},MATCH(C1,{0,6,10,12}))&" Points"

--
KL
[MVP - Microsoft Excel]
RU: http://www.mvps.ru/Program/Default.aspx
ES: http://mvp.support.microsoft.com/?LN=es-es
EN: http://mvp.support.microsoft.com/?LN=en-us
Profile: https://mvp.support.microsoft.com/profile=AB32F8EE-8ED3-4AB9-ADDA-9E6C73C09A36


Mark Solesbury said:
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.
Click to expand...
Click to expand...
 
Back
Top