Trying to get a blank cell.

  • Thread starter Thread starter Brad Gover
  • Start date Start date
B

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.
 
Hi Brad,

Under Tools > Options > View > uncheck Zero Values.

HTH
Regards,
Howard
 
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
 
Back
Top