Need help; multiple condition formula

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.
 
C

CLR

=IF(ISTEXT(A1),"COUNTIF-AMOUNT",IF(ISNUMBER(A1),A1*1.1,"LOOKUP-AMOUNT"))

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple conditions 8
Multiple Condition Formula 1
Multiple IF conditions 3
Multiply with Vlookup value from another Worksheet 0
Help with Date in SUMPRODUCT 5
Help with a formula for a Time Sheet. 1
Needs help combining functions. 3
formula to lookup employee name and return data from multiple rows 1

Top