Having a cell remain blank when using formulas

Posted on 2012-09-04
Last Modified: 2012-09-04
I have a value in D1, and I'm subtracting from it the value in C1, with the difference between these two appearing in E1. What I would like to do is have the cell in E1 remain blank until both C1 and D1 have values in them. I am trying to avoid having a zero in E1.

Does anyone have any suggestions? Thank you.
Question by:John_W_Cooney
    LVL 29

    Accepted Solution

    Try this

    Use a number format to hide zero values in selected cells

    Follow this procedure to hide zero values in selected cells. If the value in one of these cells changes to a nonzero value, the format of the value will be similar to the general number format.

        Select the cells that contain the zero (0) values that you want to hide.
        On the Format menu, click Cells, and then click the Number tab.
        In the Category list, click Custom.
        In the Type box, type 0;-0;;@


        The hidden values appear only in the formula bar Formula bar — or in the cell if you edit within the cell — and are not printed.
        To display hidden values again, select the cells, click the Cells command on the Format menu, and then click the Number tab. In the Category list, click General to apply the default number format. To redisplay a date or a time, select the appropriate date or time format on the Number tab.
    LVL 18

    Expert Comment

    I usually do something like:

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    The canonical version of this article is on my web site here: A companion presentation is available here:
    The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now