Lookup?

[Phoenix]

Hi!

If i earn for example 5000$ pr month

A table says how much tax to pay:
up to 1000$ - 230$
Up to 2000$ - 590$
etc......

If I write 5000$ in A1, I need B1 to automatically say how much
tax i need to pay (by lookup in the tax-table)


Phoeni

 

[Ron de Bruin]

Look at this great page
http://www.mcgimpsey.com/excel/variablerate.html

 

[Phoenix]

Thanx Ron. You're the man


Phoeni

 

[Phoenix]

By the way....how will the formula i
http://www.mcgimpsey.com/excel/variablerate.html work if I want t
know how much tax in $ i need to pay, and not in

 

[Phoenix]

I mean....when the table describes the amount in $, and not