Need help; multiple condition formula

  • Thread starter Thread starter SH
  • Start date Start date
S

SH

I am trying to put together a compensation worksheet that will compare three
things and compute the compensation accordingly. If the type of transaction
was "A" I would like it to pay the amount listed on a separate area of the
worksheet that I computed using a COUNTIF and LOOKUP function. If the
transaction is one that has an amount in it (I tried using cell>0), then I
would like it to take the amount in the cell and multiply it by 10%. If it
is neither of these, I would like it to look at a table (LOOKUP works for
this part) and enter the amount of compensation due.

Any help would be appreciated.
 
=IF(ISTEXT(A1),"COUNTIF-AMOUNT",IF(ISNUMBER(A1),A1*1.1,"LOOKUP-AMOUNT"))

Vaya con Dios,
Chuck, CABGx3
 
Back
Top