software

Using an quot;IFquot; formula, I need to leave empty the empty cells (I mean, cells
containing nothing). I tried many ways, f.e., putting a quot;quot; if the formula
finds and empty cell, but Excel (2003) puts something all the times.
Thanks to all.
Giovanni
quot;GRLquot; gt; wrote in message
...
gt; Using an quot;IFquot; formula, I need to leave empty the empty cells (I mean,
gt; cells containing nothing). I tried many ways, f.e., putting a quot;quot; if the
gt; formula finds and empty cell, but Excel (2003) puts something all the
gt; times.
gt; Thanks to all.
gt; Giovanni
gt;

Look at this formula:
=IF($A14=0,quot;quot;,$A14*G14)

See the two commas in the middle, surrounding the double quotation marks? Do
you have something like that in your formula?
=IF(A1=quot;quot;,quot;quot;,IF(A1=1,0,1))

HTH
--
AP

quot;GRLquot; gt; a écrit dans le message de
...
gt;
gt; quot;Doug Kanterquot; gt; ha scritto nel messaggio
gt; ...
gt; gt; quot;GRLquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; Using an quot;IFquot; formula, I need to leave empty the empty cells (I mean,
gt; gt;gt; cells containing nothing). I tried many ways, f.e., putting a quot;quot; if
the
gt; gt;gt; formula finds and empty cell, but Excel (2003) puts something all the
gt; gt;gt; times.
gt; gt;gt; Thanks to all.
gt; gt;gt; Giovanni
gt; gt;gt;
gt; gt;
gt; gt; Look at this formula:
gt; gt; =IF($A14=0,quot;quot;,$A14*G14)
gt; gt;
gt; gt; See the two commas in the middle, surrounding the double quotation
marks?
gt; gt; Do you have something like that in your formula?
gt; gt;
gt; Thank you, but my problem is a little more complex: I have a column with
all
gt; the cells containing only quot;1quot; or quot;0quot; or being empty. I need to reverse
the
gt; quot;1quot;'s into quot;0quot;'s, and vice versa, and to leave the empty cells as they
are.
gt; I'm not able to find how to do it.
gt; Giovanni
gt;
gt;

quot;GRLquot; gt; wrote in message
...
gt;
gt; quot;Doug Kanterquot; gt; ha scritto nel messaggio
gt; ...
gt;gt; quot;GRLquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Using an quot;IFquot; formula, I need to leave empty the empty cells (I mean,
gt;gt;gt; cells containing nothing). I tried many ways, f.e., putting a quot;quot; if the
gt;gt;gt; formula finds and empty cell, but Excel (2003) puts something all the
gt;gt;gt; times.
gt;gt;gt; Thanks to all.
gt;gt;gt; Giovanni
gt;gt;gt;
gt;gt;
gt;gt; Look at this formula:
gt;gt; =IF($A14=0,quot;quot;,$A14*G14)
gt;gt;
gt;gt; See the two commas in the middle, surrounding the double quotation marks?
gt;gt; Do you have something like that in your formula?
gt;gt;
gt; Thank you, but my problem is a little more complex: I have a column with
gt; all the cells containing only quot;1quot; or quot;0quot; or being empty. I need to
gt; reverse the quot;1quot;'s into quot;0quot;'s, and vice versa, and to leave the empty cells
gt; as they are. I'm not able to find how to do it.
gt; Giovanni
gt;

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
quot;Ardus Petusquot; gt; ha scritto nel messaggio
...
gt; =IF(A1=quot;quot;,quot;quot;,IF(A1=1,0,1))
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;GRLquot; gt; a écrit dans le message de
gt; ...
gt;gt;
gt;gt; quot;Doug Kanterquot; gt; ha scritto nel messaggio
gt;gt; ...
gt;gt; gt; quot;GRLquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt;gt; Using an quot;IFquot; formula, I need to leave empty the empty cells (I mean,
gt;gt; gt;gt; cells containing nothing). I tried many ways, f.e., putting a quot;quot; if
gt; the
gt;gt; gt;gt; formula finds and empty cell, but Excel (2003) puts something all the
gt;gt; gt;gt; times.
gt;gt; gt;gt; Thanks to all.
gt;gt; gt;gt; Giovanni
gt;gt; gt;gt;
gt;gt; gt;
gt;gt; gt; Look at this formula:
gt;gt; gt; =IF($A14=0,quot;quot;,$A14*G14)
gt;gt; gt;
gt;gt; gt; See the two commas in the middle, surrounding the double quotation
gt; marks?
gt;gt; gt; Do you have something like that in your formula?
gt;gt; gt;
gt;gt; Thank you, but my problem is a little more complex: I have a column with
gt; all
gt;gt; the cells containing only quot;1quot; or quot;0quot; or being empty. I need to reverse
gt; the
gt;gt; quot;1quot;'s into quot;0quot;'s, and vice versa, and to leave the empty cells as they
gt; are.
gt;gt; I'm not able to find how to do it.
gt;gt; Giovanni
gt;gt;
gt;gt;
gt;
gt;