software

Hi all,

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

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?

------------------------
Boethius1------------------------------------------------------------------------
Boethius1's Profile: www.excelforum.com/member.php...oamp;userid=30497
View this thread: www.excelforum.com/showthread...hreadid=521536You do know that links to other files require those files to be open?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Boethius1quot; gt; wrote
in message ...
gt;
gt; Hi all,
gt;
gt; =IF(AND('C:\PRODUCTION\Cutting Priority
gt; Lists\[cpleger.xls]Sheet1'!M14=3,'C:\PRODUCTION\Cutting Priority
gt; Lists\[cpleger.xls]Sheet1'!C14lt;gt;quot;quot;),'C:\PRODUCTION\Cutting Priority
gt; Lists\[cpleger.xls]Sheet1'!C14,quot;quot;)
gt;
gt; The above equation ocassionally pulls through N/A in differing multiple
gt; cells but when I open cpleger file the N/A fixes itself. In cpleger file
gt; the rows are constantly moving, presume this accounts for why N/A is
gt; found in differing ammounts and different cells. However after saving
gt; changes to each file when open original file on its own the N/A cells
gt; return. Is this being caused by the equation or other mysterious
gt; happenings?
gt;
gt; ----------------------
gt;
gt;
gt; --
gt; Boethius1
gt;
gt;
gt; ------------------------------------------------------------------------
gt; Boethius1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30497
gt; View this thread: www.excelforum.com/showthread...hreadid=521536
gt;

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

-------------------------------------
Boethius1------------------------------------------------------------------------
Boethius1's Profile: www.excelforum.com/member.php...oamp;userid=30497
View this thread: www.excelforum.com/showthread...hreadid=521536
Hi,
the C:\PRODUCTION\Cutting Priority Lists\ part of the equation means
the file does not have to be open.

---------------------
Boethius1------------------------------------------------------------------------
Boethius1's Profile: www.excelforum.com/member.php...oamp;userid=30497
View this thread: www.excelforum.com/showthread...hreadid=521536