I'm trying to develop a point system here at work to give a certain
amount of points for receiving a certain grade. I'm not that well
versed in Excel so I don't know what these formulas mean in English.

=IF(C6="","",IF(C6<$C$12,0,IF(C6$C$14,$D$14,IF(C6 <=$C$13,((C6-$C$12)/($C$13-$C$12))*($D$13-$D$12)+$D$12,IF(C6$C$13,((C6-$C$13)/($C$14-$C$13))*($D$14-$D$13)+$D$13,0)))))

Target Points
C12 594.49 1.25 D12
C13 540.44 5.00 D13
C14 491.31 10.00 D14

With the formula above, when I enter 594.49 into cell C6 I'm getting
10.00 pts when I should be getting 1.25 points.


I created this one and it works exactly as I intended, but I can't just
copy and paste. I will need to create about 10 of these little point
matrix's and all of them have different targets and different reward
points.

=IF(G6="","",IF(G6<$G$12,0,IF(G6$G$14,$H$14,IF(G6 <=$G$13,((G6-$G$12)/($G$13-$G$12))*($H$13-$H$12)+$H$12,IF(G6$G$13,((G6-$G$13)/($G$14-$G$13))*($H$14-$H$13)+$H$13,0)))))

Target Points
G12 4.50 5.00 H12
G13 4.75 20.00 H13
G14 5.00 40.00 H14

Any help would be greatly appreciated.

-Chuck-


--
Dropdown3
------------------------------------------------------------------------
Dropdown3's Profile: http://www.excelforum.com/member.php...o&userid=30321
View this thread: http://www.excelforum.com/showthread...hreadid=505440