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

HTH
--
AP

"GRL" <giorel@tiscali.it> a écrit dans le message de
news:444a539e@newsgate.x-privat.org...
>
> "Doug Kanter" <ancientangler@hotmail.com> ha scritto nel messaggio
> news:Ehs2g.7929$tT.7852@news01.roc.ny...
> > "GRL" <giorel@tiscali.it> wrote in message
> > news:444a4f81$1@newsgate.x-privat.org...
> >> 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
>
>