We help IT Professionals succeed at work.

How to make a cell within excel display nothing (show blank) if a related cell is empty?

philpre
philpre asked
on
I have the following formula inside cell BC39: IF(BA39>0,"HIGHER",IF(BA39<0,"LOWER","FLAT")).  
The formula works fine, except that if the value of cell BA39 has not been entered yet, cell BC39 always displays FLAT.  If the value of cell BA39 has not yet been entered, I want cell BC39 not to display anything and show empty until I have entered the value into cell BA39.
Comment
Watch Question

Sam Simon NasserIT Support Professional

Commented:
what will happen if you put like this?
IF(BA39>0,"HIGHER",IF(BA39<0,"LOWER",""))

Open in new window

Most Valuable Expert 2011
Top Expert 2011
Commented:
You can use:
=IF(Ba39="","",IF(BA39>0,"HIGHER",IF(BA39<0,"LOWER","FLAT")))

Author

Commented:
Perfect!!!