Multiple IF statements in a single cell

[Ron Ramer]

I am doing a set of projections for a corporate client and
want to create a formula to calculate the federal income
tax. Is there a way that I can create a formula in a
single cell to calculate the tax due by using an IF
statement to look at the net income before taxes? I
currently have a formula that is an IF/OR statement that
will allow me to calculate the tax due if the income falls
within two tax brackets. I can not figure out how to
create the formula to determine if there is a loss or the
income falls within a different tax bracket. Thank you
for your repsonses and your help.

 

[Dave Peterson]

Without any knowledge of your data, I'd look at =vlookup() in help.

You can build a table with the values you need. (You can only have 7 nested
functions in a worksheet formula and you might come up against that pretty
quickly.)

Chip Pearson has some notes about bracket pricing at:
http://www.cpearson.com/excel/pricing.htm

You may want to see if that gives you any ideas.