Linking Information in Sheets based on its content
 

I am trying to link information in several worksheets so that if I change the
information on the first one, then the others would be updated. My first
worksheet includes various phone numbers (home & mobile). If there is a
phone number available, it links properly - however, if they do not have a
number, then the value comes up as "0". I would rather have the entry blank.
What formula would I use? Currently, it is set up as 'Worksheet1'!B2.
Would it be an "IF/OR" function?

Thank you for your assistance.

Linking Information in Sheets based on its content
 

You could use conditional format so that the foreground colour is set
to the same colour as the background if the cell contents are equal to
zero. Alternatively, the formula;

= IF(Worksheet!B2 = "", "", Worksheet!B2)

Pete