"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
--