Hi Max,

I was careful to put 'think' as the OP wasn't absolutely clear, but on the
balance AND seemed more probable :-))

Bob


"Max" wrote in message
...
"Bob Phillips" wrote
I think Max means AND not OR

Thanks for the correction, Bob !

Should have paid greater attention to the OP's lines:
The data is in both M6 and N6.
If both of these are empty, it should do nothing,
if they are populated, I want to copy the cells over.

Corrected: =IF(AND(Fair!M6="",Fair!N6=""),"",Fair!A6)

Or, with cell references fixed to point at cols M & N
if the formula is to be copied across, and filled, then:
=IF(AND(Fair!$M6="",Fair!$N6=""),"",Fair!A6)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--