Have a cell for the support hours. I'll assume A1 contains this
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 be
$12500
If a1 is greater than 105 hours, the charge will be $12500 + the number
of hours over 105 multiplied by your hourly rate.
See how you go.
--
random1970
------------------------------------------------------------------------
random1970's Profile:
http://www.excelforum.com/member.php...o&userid=32112
View this thread:
http://www.excelforum.com/showthread...hreadid=519213