View Single Post
  #3   Report Post  
Old April 22nd 06, 05:10 PM posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default Leaving an empty cell empty

=IF(A1="","",IF(A1=1,0,1))

HTH
--
AP

"GRL" a écrit dans le message de
...

"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