Yes I have. If I could get a example with actual numbers in it I might be
able to understand it better.

"Myrna Larson" wrote:

Have you looked at Help for this function? It includes an example.

On Tue, 30 Nov 2004 04:27:02 -0800, "DWright"
wrote:

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.