Why is this formula returning "#Name?"?

R

RPS

Hi,

I'm using the attached formula across 30+ rows on a number of
worksheets in a number of workbooks. On every worksheet the formula
returns #Name? in Row 17, but returns the correct value everywhere
else. If I open the linked files instead of updating the links the
correct value is returned in Row 17 as well. This is obviously time
consuming and annoying. Can anyone help?

=+IF(('http://mysite.xxxfoods.com.au/personal/rsutherl/NSW_C8/Shared
%20Documents/[2_Comm_NSW_C8_09.xls]Summary'!D16)="","0",('http://
mysite.xxxfoods.com.au/personal/rsutherl/NSW_C8/Shared%20Documents/
[2_Comm_NSW_C8_09.xls]Summary'!D16))

Thanks in advance,

Rohan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct formula problem 5
VLOOKUP returning #N/A result 2
formula error 1
Lookup returning #n/a 1
Help Writing a Complicated Formula 3
return adjacent cell's value based on formula 6
#NAME! Error 3
SUM using results from an Adress-formula 3

Top