| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calculating different percentages depending on amount
I'd appreciate help with a formula I need a formula to calculate the following 4.5% of any amount up to and equal to $41,100.00 PLUS 6.00% on any amount above $41,100. ie $20,000 would be (20,000 x .045) $900.00 ie $50,000 would be [(41,100 x .05) + (8,900 x .060)] $2,383.50 Thanks Peter -- pgruening ------------------------------------------------------------------------ pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011 View this thread: http://www.excelforum.com/showthread...hreadid=478783 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating percentages in pivot tables on subtotals | Excel Worksheet Functions | |||
| Calculating number of periods when payment amount changes | Excel Worksheet Functions | |||
| calculating percentages | Excel Discussion (Misc queries) | |||
| Calculating total amount of sales for each salesman | Excel Worksheet Functions | |||
| Calculating Percentages with Variables | Excel Worksheet Functions | |||
Threaded Mode
