how to multiply below and above with a sigle cell referrance
 

Dear Clayton,

Thanks for your co-operation in improve my excel knowledge.

I have one problem regarding tax calculation, Please guide me to solve
it.

Income Slabs
Up to Tax Rate Tax Amount
350000 100000 No Tax 0
100000 to 150000 10% 5000
150000 to 250000 20% 20000
250000 and above 30% 30000
55000
I want to calculate the tax total payable on Rs. 350000/- which means I want
to calculate the tax
based on A8


I want to know the result with cell A 8 referrance I.e., multiply with less
than and morethan with single referrance and add it in the same formule.

Your help is higly appreciated.

Thankyou.

Sekhar Dasari.