Nesting If AND and OR all at once

**jswainson** · 08-10-2012, 01:35 PM

Hi,

In column M i have a series of dates. In columns N and O i have price data. I would like to be able to draw out into column P all the dates where (N1>0 AND O1<0) or (N1<0 AND O1>0), i.e. where one column contains a positive number and the other column contains a negative number.
I can write it out in English but can't seem to get the AND and OR in the right place to make this work.

IF(((N1>0 AND O1<0) OR (N1<0 AND O1>0)), M1,"")

Please could someone help?

Thanks
Jo

**K m** · 08-10-2012, 01:42 PM

If(OR(AND(N1>0, O1<0),N1<0, O1>0), M1,"")

**tigeravatar** · 08-10-2012, 01:45 PM

Jo,

Originally Posted by jswainson

IF(((N1>0 AND O1<0) OR (N1<0 AND O1>0)), M1,"")

=IF(OR(AND(N1>0,O1<0),AND(N1<0,O1>0)),M1,"")

**CheshireCat** · 08-10-2012, 01:47 PM

How about:

Please Login or Register  to view this content.

**jswainson** · 08-10-2012, 01:55 PM

Thanks very much - that works.

Jo

Nesting If AND and OR all at once

LinkBack

Thread Tools

Rate This Thread

Display

Nesting If AND and OR all at once

Re: Nesting If AND and OR all at once

Re: Nesting If AND and OR all at once

Re: Nesting If AND and OR all at once

Re: Nesting If AND and OR all at once

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions