Open both files first, apply the link by clicking the other cell or by
coping and paste special as link, then you can close the other workbook and
excel will put in the path for you so if I open a file, then type

=IF(then I click on the cell in the other file,apply the condition, click
again, apply if condition is FALSE, add a closing parenthesis and press
enter, this will for example give me

=IF('[check register.xls]OCTOBER 2005'!$N$7<"",'[check register.xls]OCTOBER
2005'!$N$7,"")

now I close the check register file

and my formula changes to

=IF('K:\common\ACCT\Period06\[check register.xls]OCTOBER
2005'!$N$7<"",'K:\common\ACCT\Period06\[check register.xls]OCTOBER
2005'!$N$7,"")

it is always much better to apply a formula with all workbooks in question
open, then you'll get the paths for "free"


--

Regards,

Peo Sjoblom



--

Regards,

Peo Sjoblom



"sdp777" wrote in message
...
How would this be formated if it was coming from another file altogether?
Im stuck he
=IF(\\SERVER\USERS\username\test1.xls#Sheet2!A1<" ",Sheet2!A1,"")

Thanks for the assistance. Is Excel the best option for attempting to
link
files for example for employee time sheets in to a master spreadsheet?

Im sure Excel can do it, but the support literature doesnt articulate how.
Steven



"Domenic" wrote:
Try something like...

=IF(Sheet2!A1<"",Sheet2!A1,"")

Hope this helps!

In article ,
"Lucylambkin" wrote:

I want to insert a formula/function that inserts data from another
spreadsheet, but that if the cells in the other spreadsheet are blank
they
are left blank.

I have tried setting up a formula, but if the cell in the other
spreadsheet
is blank, then the spreadsheet which has the formula shows a 0 in the
cell.

Can anyone help