Joining IF Statements

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

Guest

I am trying to join these 3 IF statements. Can't seem to get it to work.

if q11="A" then 0

if q11="OK" and k11="Buy" then (N11-M11)*L11*100) otherwise
(M11-O11)*L11*100)

if q11="Adjust" and k11="Buy" then (N11-Q11)*L11*100) otherwise
(Q11-O11)*L11*100)

Thank you in advance.
 
.......Copy paste....
= L11*100* ( if (Q11="A",0,if(and(Q11="OK", K11="Buy"),N11-M11, M11-O11 ))+
if(Q11="A",0,if(and(Q11="Adjust", K11="Buy"),N11-Q11, Q11-O11 )))
......
pls. reply fror my mistake...thanks
 
Think you've got some typo's!

You've got Q11 containing text, and then you're using Q11 in calculations.

Might there be other typo's also?
 
you're really right thats why carl has to test his joining requirement !! its
give and take....
 

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

Evaluating more than 30 conditions using a formula 1
If and Countif 2
If with countif or counta 3
VLookup 4
I want excel to input data in a cell from multiple cell choices 7
Vlookup possibly ? 3
Using AND OR 4
Function doesn't work 2

Back
Top