View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default Leaving an empty cell empty

"GRL" wrote in message
...
Using an "IF" formula, I need to leave empty the empty cells (I mean,
cells containing nothing). I tried many ways, f.e., putting a "" if the
formula finds and empty cell, but Excel (2003) puts something all the
times.
Thanks to all.
Giovanni


Look at this formula:
=IF($A14=0,"",$A14*G14)

See the two commas in the middle, surrounding the double quotation marks? Do
you have something like that in your formula?