Calculation Question

[Goofy]

We have a client that pays 12,500.00 for monthly support. If they are over
105 hours in the month they pay an additional $125.00 an hour. They still
pay the 12,500 even if they are under the 105 hours.


a b
Hours cost
1 120 =sum(?

 

[Michael M]

Hi Goofy
Try this:

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

HTH Michael

 

[MarkN]

This might help, assuming your hours are in A1, paste this formula into B1:
=IF(A1>105,12500+((A1-105)*125),12500)

 

[Ragdyer]

Try this:

=12500+125*(A1>105)*(A1-105)