how do i make a cell stay blank

Tags:

Microsoft Office excel 2007 home & stude...

trejo75 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 •

Humar 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

› [Solved] How do you make a cell with a formula in it appear blank?
› how do i highlight a cell in excel if the dat
› how do I make a formula to skip blank cells?
› I want a cell to show ---- when empty
› [Solved] How do I: if X2 = A2, then change X2 to red?
› How do I make the first letter of each word i
› How do I create a print macro in Excel

See More ↓

Ask Your Question

Weekly Poll

Do you think Google's new Pixel 4 will gain traction?

Poll Finishes In 2 Days.
Discuss in The Lounge
Poll History