View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael M
 
Posts: n/a
Default 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(?