Posted to microsoft.public.excel.misc

SueG123

external usenet poster

Posts: 3

Formula needed help from a genius!!!

I need a formula for calculating the tax on a profit amount based on the
following scales so I can quickly calculate tax payable to accrue in my
accounts
0-25k 5.3%
25-200k 15.3%
200-400K 22.4%
400-1M 28.8%
1M-5M 33.8%
eg if profit was 200k then 1st 25K @5.3 and then 175K @15.3%
Would appreciate anyone who is able to give me some help on this

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
genius wanted VBS	lost in Chicago[_2_]	Excel Discussion (Misc queries)	6	March 3rd 08 02:09 PM
Question for all the excel Genius	OSSIE	Excel Discussion (Misc queries)	2	March 3rd 06 11:31 PM
Excel Genius Required!	nutsoup	Excel Discussion (Misc queries)	4	February 5th 06 07:43 AM
Find and match totals Genius Req. this should be easier to read	James	Excel Worksheet Functions	1	October 3rd 05 10:12 PM
Find and match totals Genius Req.	James	Excel Worksheet Functions	0	October 3rd 05 07:31 PM

All times are GMT +1. The time now is 10:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us