How to use a tax type table (if/then with lots of detail) in a fo.
 

I'm trying to create a formula that includes a tax type table such as If
income is within $100 and $200, then add $10 to 25% of income over $100. I'm
not sure how to type the table and how to word the formula.
Any suggestions

take a look at

http://www.mcgimpsey.com/excel/variablerate.html

In article ,
everyday joe <everyday wrote:

I'm trying to create a formula that includes a tax type table such as If
income is within $100 and $200, then add $10 to 25% of income over $100. I'm
not sure how to type the table and how to word the formula.
Any suggestions

A comprehensive explanation can be found at

http://www.mcgimpsey.com/excel/variablerate.html

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"everyday joe" <everyday wrote in message
...
I'm trying to create a formula that includes a tax type table such as If
income is within $100 and $200, then add $10 to 25% of income over $100.
I'm
not sure how to type the table and how to word the formula.
Any suggestions