Results 1 to 10 of 10

How to avoid a 0 when linking to a blank cell with formatting

Threaded View

  1. #1
    Registered User
    Join Date
    11-17-2010
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2003
    Posts
    12

    How to avoid a 0 when linking to a blank cell with formatting

    Here's the situation, i want cell B1 to be linked to cell A1, so that when i enter data in to cell A1 it appears in B1 as well. However, when A1 is blank, i do not want B1 to show a zero. I know the problem can be solved with the if() function, but I believe there must be a formatting option to solve this. is there one? I've attached a file for more information.
    Attached Files Attached Files
    Last edited by CantripGhost; 11-20-2010 at 05:56 PM.

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