I think Max means AND not OR

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Max" wrote in message
...
Just a 2nd guess on this, from the earlier attempt in your earlier post:
=IF(OR(Fair!M6="",Fair!N6=""),"",Fair!A6)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--