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.