Format cell if cell is zero

  • Thread starter Thread starter Sokoban
  • Start date Start date
S

Sokoban

I have Excel that show text after Calculating in the cell. I want the
cell dosen't show the text before the cell is typing any value.

How I do that ??

// sokoban
 
If the value is typed in cell B3, and the text is in C3, enter the
following formula in cell C3:
=IF(B3=0,"","This is the text")
or
=IF(B3="","","This is the text")

When you type in B3, the text will appear in C3
 
Back
Top