Calculating a scoring system (issue #1)

[jenparker1234]

Hi,

I'm working to create a scoring system. I'm not sure if this can eve
be done, but if it can, someone here should be able show me how!

#1. Certain values have certain scores. They are as follows:

FCL Points
<2.0% = 8
<2.25% = 6
<3.0% = 4

3.0% = 2

<1.0% = 0

Column P will be the score, based on the FCL percentage in colum H.
So, if cell H1 is <2.25%, then I would like cell P1 to automatically b
6 points.

I've tried some things myself, but its just not working. Pleas
help!:confused

 

[Niek Otten]

Use the VLOOKUP() function.
If you're not familiar with that function, see this tutorial

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Hi,
|
| I'm working to create a scoring system. I'm not sure if this can even
| be done, but if it can, someone here should be able show me how!
|
| #1. Certain values have certain scores. They are as follows:
|
| FCL Points
| <2.0% = 8
| <2.25% = 6
| <3.0% = 4
| >3.0% = 2
| <1.0% = 0
|
| Column P will be the score, based on the FCL percentage in colum H.
| So, if cell H1 is <2.25%, then I would like cell P1 to automatically be
| 6 points.
|
| I've tried some things myself, but its just not working. Please
| help!
|
|
| --
| jenparker1234
| ------------------------------------------------------------------------
| jenparker1234's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36266
| View this thread: http://www.excelforum.com/showthread.php?threadid=568617
|

 

[somethinglikeant]

I used nested IF statements after writing out a number line for your
scores.
As long as the ranges don't overlap I wrote this formula to place in
P2, giving you the score of H2

=IF(H2>=3,2,IF(H2>2.25,4,IF(H2>2,6,IF(H2>1,8,IF(H2>0,1,"-")))))


Plus you may need to change some > or < to >= or <=

http://www.excel-ant.co.uk