+ Reply to Thread
Results 1 to 2 of 2

Linking Information in Sheets based on its content

  1. #1
    Laura
    Guest

    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.

  2. #2
    Pete
    Guest

    Re: 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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1