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...o&userid=36266
View this thread: http://www.excelforum.com/showthread...hreadid=568617