Using result from or funtcion in if statement

  • Thread starter Thread starter Colm O'Brien
  • Start date Start date
C

Colm O'Brien

i have a formula =OR(G2="DTA",G2="LTA") in cell AI2

I have an other formula
=IF(G2="Multiplan",LOOKUP(U2,'Commission Rates'!$A$2:$A$46,'Commission
Rates'!$C$2:$C$46),IF(G2="Health Care
Inc",IF(X2>=11,95.84,IF(X2<5,0,LOOKUP(Z2,'Commission
Rates'$A$2:$A$46'Commission
Rates'!$C$2:$C$46),))),IF(AI2="TRUE",IF(H2>=11,111.81,-8),"error colm")))

when AI2 is true this should return either 111.81 or -8 but is not where
have i gone wrong


thanks
colm
 

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

count cell if value present in every other cell + criteria 2
Working with Excel in Access 1
Multiple functions/formulas... 3
Using reference column # in IF Statement 4
IF Statement with AND Statement 4
#N/A 1
Volitile Formula 1
SQL Insert Into Statement 3

Back
Top