how to multiply below and above with a sigle cell referrance

  • Thread starter Tax calculation with a single referrance
  • Start date
T

Tax calculation with a single 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

database designing for paying monthly salary 0
How to calc. Inflation in a spreadsheet 0
Increase value of number in formula/using named cells. And use ofIF sentence 10
How to count hours- and multiply with my wage per hour... 4
How do I create an if function with 9 variables and 6 multipliers? 3
How to compare Multiple Rows and Columns to get data 0
How to get exact hours above a spesific time? 2
How do I asssign a values to two cells and multiply them together 3

Top