Calculating a scoring system (issue #1)
 

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!:confused:


--
jenparker1234
------------------------------------------------------------------------
jenparker1234's Profile: http://www.excelforum.com/member.php...o&userid=36266
View this thread: http://www.excelforum.com/showthread...hreadid=568617

Calculating a scoring system (issue #1)
 

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

"jenparker1234" wrote in message
news:jenparker1234.2c2kcr_1154785206.4932@excelfor um-nospam.com...
|
| 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!:confused:
|
|
| --
| jenparker1234
| ------------------------------------------------------------------------
| jenparker1234's Profile: http://www.excelforum.com/member.php...o&userid=36266
| View this thread: http://www.excelforum.com/showthread...hreadid=568617
|

Calculating a scoring system (issue #1)
 

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(H22.25,4,IF(H22,6,IF(H21,8,IF(H2 0,1,"-")))))


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

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