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