Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to refer to another cell (Excel 2000)

    Hi,

    Here is the problem:
    I have what I call a "master cell" that has no value in it at all (it is a "blank" or space). This is the cell that the other cells refer to.
    What I want to do is set up other cells that refer to the "master cell" and return the master cell's value (i.e. a blank), but Instead the other cells have a value of 0 in them!

    What am I doing wrong? (I tried cell formatting text, general etc) but this doesnt work.

    (Example: cell A1 is the blank cell (no value in it)
    In cell D3 I want the value of A1 so I wrote =$A1, but it returns a 0 instead of a "blank")

    TIA!
    Ivan Weinstein <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  2. #2
    Lounger
    Join Date
    Jan 2001
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to refer to another cell (Excel 2000)

    I found the answer. Uncheck the show zero values box in tools>options

    thanks anyway. <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: How to refer to another cell (Excel 2000)

    You can use the formula in D3:
    =if(isblank(a1),"",A1)

    Then it will display a null string (""), it won't be BLANK! The only way a cell can be blank is to have NOTHING in it. You can change what displays by changing the formula (if you want it to say "cell is blank", for exmple):
    =if(isblank(a1),"cell is blank",A1)


    Hiding zeroes will work but it is "non-selective" that is ALL cells that evaluate to zero will not be displayed.
    Other options:
    Format the appropriate cells (format cells) using a format to "hide" the zeroes (similar to your way, but slective to only the cells you pick)
    Use a conditional format to make the cell text the same color of the background when A1 is blank (warning this ONLY works on blak/white printers if it is white text on white or black text on black. any other color text with the same background will still print on most b/w printers!

    Steve

Posting Permissions

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