Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Referenced Cell Format

    Excel 97 SR-2. When I reference a cell in Worksheet One, I want the cell in Worksheet Two to be blank when the cell in Worksheet One is blank. Now, I either get a "0" displayed in Worksheet Two, or I get the cell reference displayed if I select Text format for the cells.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Referenced Cell Format

    You could try a conditional formula in your reference, so for example instead of using =Sheet1!A1, you could use =IF(Sheet1!A1="","",Sheet1!A1).

    Andrew C

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Referenced Cell Format

    There are several ways to get what you want.

    1- You can select Options from the Tools menu. Then on the View Tab uncheck the "Zero values" box. This will cause all zero values to display as blank.

    2- Select the cells and then select Cells from the Format menu. Select Custom, and create a format like: #,##0.00;-#,##0.00;

    3- Use a formula like: =If(Sheet1.A1 = "", "", Sheet1.A1)
    Legare Coleman

  4. #4
    New Lounger
    Join Date
    Jan 2001
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Referenced Cell Format

    Thanks for the responses. The IF statement worked perfectly.

Posting Permissions

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