hide value of formula until cells are filled

September 23, 2010 at 06:33:42
Specs: Windows XP
I have used this formula =IF(H3>1,"closed","Open") and I have the word "open" going all the way down my sheet. How do I hide the word until I a # is in cell H3. So I want the cell that currently says "open" to be empty until I fill the cell H3...

See More: hide value of formula until cells are filled

Report •


#1
September 23, 2010 at 06:47:41
Try:

=IF(ISBLANK(H3),"",IF(H3>1,"closed","Open"))

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question