Leaving an empty cell empty

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

"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?

"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

=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
>
>

"GRL" <giorel@tiscali.it> wrote in message
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
>

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

This is the solution!
Thank you, Ardus, and thank you all.
Giovanni
"Ardus Petus" <ardus.petus@laposte.net> ha scritto nel messaggio
news:usJk8diZGHA.3684@TK2MSFTNGP05.phx.gbl...
> =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
>>
>>
>
>