Calculation Qustion

[Goofy]

Have a calculation that provides the results from.

We charge $12,500 on a support contract. If the client goes over 105 hours
we charge an additional $125.00 per hour for the hours over 105 hours. In
this case they had 120 hours in this month. If they are under they still
pay the 12,500


Cell 1 Cell 2
Total Hours Cost

120 =sum(?


What would be the proper calculation.

 

[random1970]

Have a cell for the support hours. I'll assume A1 contains thi
number.

In cell B1, you want the total charge to appear. Type the formula

=IF(A1<=105,12500,12500+(A1-105)*125)

So, if a1 is less than or equal to 105 hours, the charge will b
$12500
If a1 is greater than 105 hours, the charge will be $12500 + the numbe
of hours over 105 multiplied by your hourly rate.

See how you go