View Single Post
  #1   Report Post  
prince
 
Posts: n/a
Default place empty cell with zero

I am trying to place zero in place of empty cells in my worksheet, i used
formula
=IF(A2="",0,A2)
But this formula is also placing zero for a cell having value(number), i
donot want the cells with values to be filled with zero, i want only empty
cells in my sheet to be filled with zero.
can anyone help me plz.