View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
random1970
 
Posts: n/a
Default Calculation Qustion


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