Joining IF Statements
 

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.

Joining IF Statements
 

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

"carl" wrote:

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.

Joining IF Statements
 

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?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"carl" wrote in message
...
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.

Joining IF Statements
 

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

"RagDyer" wrote:

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?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"carl" wrote in message
...
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.