how do i make a cell stay blank

Tags:
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?

Example:
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

Report •

#1
September 14, 2010 at 04:02:36
Hi,

How about:
=IF(OR(A1="",A2="",A2=0),"",A1/A2)

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

Regards


Report •
Start a discussion
Related Solutions
See More ↓


Ask Question