=IF(AND equation not applying to whole document)

B

Boethius1

Hi all,

=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,"")

The above equation ocassionally pulls through N/A in differing multiple
cells but when I open cpleger file the N/A fixes itself. In cpleger file
the rows are constantly moving, presume this accounts for why N/A is
found in differing ammounts and different cells. 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?

----------------------:)
 
B

Bernard Liengme

You do know that links to other files require those files to be open?
best wishes
 
B

Boethius1

Hi,
the C:\PRODUCTION\Cutting Priority Lists\ part of equation means that
the file doesn't have to be open.

-----------------------------------:)
 
B

Boethius1

Hi,
the C:\PRODUCTION\Cutting Priority Lists\ part of the equation means
the file does not have to be open.

-------------------:)
 
Top