"GRL" wrote in message
...

"Doug Kanter" ha scritto nel messaggio
...
"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?

Thank you, but my problem is a little more complex: I have a column with
all the cells containing only "1" or "0" or being empty. I need to
reverse the "1"'s into "0"'s, and vice versa, and to leave the empty cells
as they are. I'm not able to find how to do it.
Giovanni


Except for the problem with empty cells, does your formula work otherwise?
If yes, please post the formula here.