Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation Qustion
Have a calculation that provides the results from.
We charge $12,500 on a support contract. If the client goes over 105 hours we charge an additional $125.00 per hour for the hours over 105 hours. In this case they had 120 hours in this month. If they are under they still pay the 12,500 Cell 1 Cell 2 Total Hours Cost 120 =sum(? What would be the proper calculation. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation speed issue | Excel Discussion (Misc queries) | |||
Commission Calculation with IF Stmt. | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |