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

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

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