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?

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 •
Related Solutions


Ask Question