Formula Meaning In English

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-