Joining IF Statements

[carl]

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.

 

[romelsb]

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

 

[RagDyer]

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?

 

[romelsb]

you're really right thats why carl has to test his joining requirement !! its
give and take....