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.

Combining IF's
 

Hi Carl,

There's some logic missing from your request. IF tests take the form of:
=IF(TEST=TRUE,TRUE,FALSE)
and you can nest them (up to 7 levels), like:
=IF(TEST=TRUE,TRUE,IF(TEST=TRUE,TRUE,FALSE))

So, while it's easy enough to combine:
if q11="A" then 0
=IF(Q11="A",0,FALSE)
with:
if q11="OK" and k11="Buy" then (N11-M11)*L11*100) otherwise
(M11-O11)*L11*100)
=IF(AND(Q11="OK",L11="Buy"),(N11-M11)*L11*100),(M11-O11)*L11*100))
using:
=IF(Q11="A",0,IF(AND(Q11="OK",L11="Buy"),(N11-M11)*L11*100),(M11-O11)*L11*10
0))
You've already used up all the available TRUE & FALSE conditions and there's
nothing to connect the formula with:
if q110 and k11="Buy" then (N11-r11)*L11*100) otherwise
(r11-O11)*L11*100)
=IF(AND(Q110,K11="Buy"),(N11-R11)*L11*100),(R11-O11)*L11*100))
or:
if none of these conditions exist, "Check"
=IF(TEST=TRUE,TRUE,"Check")

I think you need to provide a clearer explanation of the relationships.

Cheers

--
macropod
[MVP - Microsoft Word]


"carl" wrote in message
...

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.