"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