Calculation Question
 

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(?

Calculation Question
 

Hi Goofy
Try this:

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

HTH Michael

"Goofy" wrote:

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(?

Calculation Question
 

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


"Goofy" wrote:

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(?

Calculation Question
 

Try this:

=12500+125*(A1105)*(A1-105)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Goofy" wrote in message
...
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(?