That did it and I did add shat if i7 is greater than 150
Could you explain How to create a table of tax percentages to use with
VLOOKUP?
Thank you.

"Myrna Larson" wrote:

The equal sign in the middle of the formula isn't correct. Should probably be
a comma. And this part is not correct:

i7101<150

This should work, but you don't say what to return if i7 is greater than 150.

=if(i7<100,i7*.04769,if(i7<150,i7*.05693))

Remember, you can have only 7 nested IF formulas. You might find it easier to
write the formulas if you create a table to use with VLOOKUP. This table would
have the amounts in the 1st column and the percentage in the 2nd.


"DWright" wrote in message
...
I am constructing a payroll spreadsheet. In the cell that calculates the
Federal TaxI have the following:
=if(i7<100,(i7*.04769)=if(i7101<150,(i7*.05693))) . The value in i7 is 140
and it returns a FALSE in cell i7 instead of a dollar amount.
Any help would be greaatly appreciated.