Click here for important information about

how do i make a cell stay blank

Microsoft Office excel 2007 home & stude...
September 13, 2010 at 23:21:11
Specs: Office Excel
How do I make the cell containing the formula appear blank unless its computing cells have data?

The formula in A3 is =A1/A2

If A1 and A2 are blank, A3 reads #DIV/0!

I want A3 to remain blank if A1 and A2 are blank. How do I do that?

See More: how do i make a cell stay blank

September 14, 2010 at 04:02:36

How about:

Then, as well as showing nothing when either A1 or A2 are empty, it shows nothing if A2 contains zero.


Report •
Related Solutions

Ask Question