Microsoft Office excel 2007 home & stude...

How do I make the cell containing the formula appear blank unless its computing cells have data? Example:

The formula in A3 is =A1/A2If 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?

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

Ask Your Question

Weekly Poll