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

B

Boethius1

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
------------------------:)
 
Top