Checking age before calculating on the basis of IF condition

[Zanys]

Hello Everyone,

I have prepared an excel to calculate Income Tax at predefined slabs. I need to modify it to some extent, so please guide me

I would like to add age condition too in it before calculation of Tax.

I am herewith attaching the excel that i prepared.

What i am trying to do is as following.

1st Column will be Amount which i will enter on my own

2nd Column - Date of Birth / AGE

3rd Column - Tax Calculation (As per tax slab)

Please check guide me.

Thanks

[Special-K]

Pls provide some exmaple data both input AND expected output.

[Beamernsw]

I just helped someone do something similar the other day. I used a helper column to separate (in this case) the age ranges by adding 1,000,000,000 for each range.

I'm not sure how this tax works out, but I made another helper column to store the total amount of tax that would have been paid for the previous full brackets up till the one that the "Amount" is in.

Those helper columns are B&C and are hidden (just select columns A:E, right-click, select unhide.

I hope it works for you.

[Zanys]

Thank you Beamernsw! That worked perfectly!!