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