Trying to get a blank cell.

[Brad Gover]

Does any one know how to get a cell formula to put in a
blank cell "" when there is no data in a corresponding
cell? I have a gage streaming in data down a column.
There are times when the cell will contain no data. The
adjacent cell calculates what to put in another cell based
upon a condition. It will put in a blank cell if the
condition is true--providing b117 has a data value in it.
However, if there is no data in b117, it puts in the
value "0" instead of the blank cell. The logic statement
is given below.

=IF(B117>5000,"",B117)
Appriciate any help.

 

[L. Howard Kittle]

Hi Brad,

Under Tools > Options > View > uncheck Zero Values.

HTH
Regards,
Howard

 

[CLR]

You could establish a Conditional Format on the cell that would change the
font color to the same color as the background color of the cell if the cell
equalled zero........therefore the zero would not show up......

Vaya con Dios,
Chuck, CABGx3