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'?

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

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'?

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

"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
---