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

A

Anita

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

Barb Reinhardt

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

Max

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'?
Click to expand...

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

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

=IF([Book1]Sheet1!A1="","",[Book1]Sheet1!A1)
 
Top