tax on salary calculation

[sna]

Hi Dear

How is it going? hopefully you're doing good
I need your help to calculate tax on salary .
Example:
5,000,000 I would do simply
1300000*0%=0
(2000000-1300000)*5%
(5000000-2000000)*10%
Then I sum this equal:35,000
Is there any formula in excel can do this more faster than this?
I attached a template with the tax table

Best wishes

[snasui]

I think the explanation and attached file in this link can help you.

Link: https://abcaus.in/income-tax/excel-inco ... rmula.html

File: https://abcaus.in/articles/income-tax/i ... ormula.xls

[sna]

Hi Dear
Thank you so much