Multiple Condition Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi Steve
try something like
=IF(A1="A",cell_on_this_worksheet,IF(ISNUMBER(A1),A1*0.1,LOOKUP(...)))
 
Back
Top