Sorry for the confusion. i will try again. If A1 is empty or has an 0 in it, I want B1 to be empty. At the same time if A1 has any number in it, I want B1 to have that number in B1. .
On Sun, Mar 8, 2009 at 12:44 AM, Brian Barker <[email protected]>wrote: > 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] > >
