Combining IF's
I am trying to combine these 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 q110 and k11="Buy" then (N11-r11)*L11*100) otherwise
(r11-O11)*L11*100)
if none of these conditions exist, "Check"
Thank You In Advance.
|