View Single Post
  #2   Report Post  
Harald Staff
 
Posts: n/a
Default

Hi

IFs are made like
=If(Test, test true then this, Otherwise this)

You missed a comma after "if true then this", and you don't have
an"otherwise"after the second test..
Also; i7101<150 is not valid syntax.

HTH. Best wishes Harald

"DWright" skrev i melding
...
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.