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