| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Progress Tax Calculator
Based on the McGimpsey formula:
=SUMPRODUCT(--(A1{0;20000;40000;60000;80000;100000}), (A1-{0;20000;40000;60000;80000;100000}), {0.05;0.01;0.01;0.01;0.01;0.01}) HTH "Bearacade" wrote: Try this... =IF(B5100000, (B5-100000)*0.1+7000, IF(B580000,(B5-80000)*0.09+5200, IF(B560000,(B5-60000)*0.08+3600, IF(B540000,(B5-40000)*0.07+2200, IF(B520000,(B5-20000)*0.06+1000, B5*.05))))) Anything over 100K, you are basically paying $7000 on the first 100K and then 10% on the rest, Anything from 80K - 100K, you are paying 5200 on the first 80K and 9% on the remainder and so on... HTH -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=553335 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i set decimal point like a calculator | Excel Discussion (Misc queries) | |||
| How do I create a graph that depicts construction progress? | Charts and Charting in Excel | |||
| How to design microsoft Excel subnet calculator | Excel Worksheet Functions | |||
| Progress bar doesn't appear when saving | Excel Discussion (Misc queries) | |||
| calculator | Excel Discussion (Misc queries) | |||
Threaded Mode
