Witholding tax based on basic pay computation

[cmaesi]

Hi! please see attached file for query.

thanks!!

[cmaesi]

Hi guys here is a much eaasier way to understand my query.

EMPLOYEE BASIC PAY STATUS BRACKET EXEMPTION % BASE TAX WITHOLDING TAX
A 18,162.50 S/ME 6 15,833.00 25% 1,875.00 2,457.38
B

what formmula can i use to automatically fill up cells exemption to base tax once basic pay and status is updated?


see attached file for a better illustration and understanding of the query.


Thank you!

[Crawfinator1]

surely you can do a little better explaining yourself?

you will need to add in a couple of new columns to specify category and sub category,
Then rearrange your table into a index/match 'able format and use an index match or if statement to calculate what you are after.

[cmaesi]

Im fixing my table right now. might to a vlookup. imma put the salary range then do the vlook up