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