=IF(AND) equation pulls through N/A cells
 

Hi all,
The below equation ocassionally pulls through N/A in differing multiple
cells but when I open cpleger file the N/A fixes itself. However after
saving changes to each file when open original file on its own the N/A
cells return. Is this being caused by the equation or other mysterious
happenings?

=IF(AND('C:\PRODUCTION\Cutting Priority
Lists\[cpleger.xls]Sheet1'!M14=3,'C:\PRODUCTION\Cutting Priority
Lists\[cpleger.xls]Sheet1'!C14<""),'C:\PRODUCTION\Cutting Priority
Lists\[cpleger.xls]Sheet1'!C14,"")

thanks
------------------------:)


--
Boethius1


------------------------------------------------------------------------
Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497
View this thread: http://www.excelforum.com/showthread...hreadid=521907