Linking Information in Sheets based on its content

L

Laura

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.
 
P

Pete

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
 
Top