[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

Having a cell remain blank when using formulas

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.
0
John_W_Cooney
Asked:
John_W_Cooney
1 Solution
 
Randy DownsOWNERCommented:
Try this

http://office.microsoft.com/en-us/excel-help/display-or-hide-zero-values-HP005199879.aspx#_Toc271715559

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;;@

 Notes

    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.
0
 
CluskittCommented:
I usually do something like:
IF(AND(D1<>"",C1<>""),D1-C1,"")
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now