At 19:31 07/03/2009 -0700, Walter Hildebrandt wrote:
Using 3.1 with WindowsXP
As I mentioned before, I can speak only for 3.0.1. (Do you know that
3.1 will be different?)
If cell A1 is empty and =IF(A1;"") is in B1, B1 will have the word
FALSE. What can be entered in B1 to get an empty B1 cell?
Well, the simplest answer is to put nothing at all into B1: that will
ensure that B1 is always empty - whatever is in A1. I'm sure that's
not what you want, but it does answer your question!
At 21:08 07/03/2009 -0700, Walter Hildebrandt wrote:
Sorry for not being clear. When A1 is empty I want to enter
something in B1 that makes B1 also empty.
That's still not clear, I'm afraid: you have failed to respond to an
earlier invitation to say what you want in B1 when A1 is *not*
empty. Making B1 empty is easy. Making B1 empty if A1 is empty but
show something else when A1 is not empty is probably your
problem. But what is the "something else"? And - crucially - what
do you want to see if A1 is zero? Or contains just a blank or blanks?
If you want zeroes in A to give empty cells in B, then my earlier suggestion:
=IF(A1=0;"";<put your other expression here>)
will work. If you want zeroes instead to be handled as values and to
give your formula result in B, then something like:
=IF(ISBLANK(A1);"";<put your other expression here>)
should work. Note that, perversely, ISBLANK() tests for empty cells,
not cells containing blanks: it is TRUE for an empty cell but FALSE
for text consisting only of a blank or blanks.
Incidentally, for readers using older versions of OpenOffice than
3.0, note that the handling of empty cells in Calc changed with
version 3.0. Details are in the help text at "empty cells;handling of".
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
