Hi
I use OO 3.01 build 9379 OOO300m15
If I have to analyze a cell I use this function (I have only the
German-Language-Package installed)
* at first I delete all blanks i
* then I convert to character
* at last I ask about the content.
I believe this formulas are the same in version 3.1 and works in
MS-EXCEL too.
Greating
Franz
Gene Young schrieb:
Brian Barker 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?
IF(A1;A1;"")
IF (A1 HAS VALUE; PLACE VALUE HERE; ELSE PLACE NULL (nothing) HERE)
