In a linked calculation how do I lose the '0' in the linked file?

I've linked 1 excel file to another. Some fields in origin file are empty,
in linked file they show as a '0'. How do I lose the '0'?

You could use something like
=if(isblank( inked info ),ValueIfTrue,ValueIfFalse)


"Anita" wrote:

> I've linked 1 excel file to another. Some fields in origin file are empty,
> in linked file they show as a '0'. How do I lose the '0'?

"Anita" wrote
> I've linked 1 excel file to another. Some fields in origin file are
empty,
> in linked file they show as a '0'. How do I lose the '0'?

Another way is to frame the link formulas along these lines:

=IF(Sheet1!A1="","",Sheet1!A1)

=IF([Book1]Sheet1!A1="","",[Book1]Sheet1!A1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---