Excel formula for Tax calculation in india

[RK Singh]

Sir
excel formula round(if($c9<=250000,0,if($c9<=500000,($c9-250000)*5%,if($c9<=750000,($c9-500000)*10%+12500,if($c9<=1000000,($c9-750000)*15%+37500,if($c9<=1250000,($c9-750000)*20%+75000,if($c9<=1500000,($c9-1250000)*20%+125000,($c9-150000)*30%+187500))))),0)
which is not working. Please help with intimation to me at "taxation_mkp@itiltd.co.in".

 

[Dave Patton]

Quote
please solve another issue to find out how many invoices issued using different series numbers like as:

You may want to create a new thread for this question.
You could post examples and expected results with the forum's XL2BB.

 

[Dave Patton]

I didn't change the formula back to the original when I extracted the array information. I didn't notice when I made the post.
See the original formula in the post below.

Tax 2021.xlsm
	A	B	C	D	E	F
1	Income	1,500,000.00		Brackets	Rate
2	Tax	187,500.00				E2 is blank
3	or	187,500.00		0	0%
4				250,000	5%
5				500,000	10%
6				750,000	15%
7				1,000,000	20%
8				1,250,000	25%
9				1,500,000	30%
1aa

Cell Formulas
Range	Formula
B2	B2	=SUMPRODUCT(--(B1>D3:D9),B1-D3:D9,E3:E9-E2:E8)
B3	B3	=SUMPRODUCT(--(B1>aB_),B1-aB_,aR_)