Joined: 04 Oct 2004
|Posted: Mon Jan 05, 2009 7:59 am Post subject:
|Calc has 2 types of valid values, text and number. All dates, times, booleans (True/False) are formatted numbers.
You may consider a blank cell as another type.
Formulas can return errors. Any calcualtion (and comparison) with an error results in an error. Calc has several functions to test the type of data: ISNUMBER, ISTEXT, ISBLANK, ISERROR (any error), ISERR(any but #NA), ISNA
The #NA value is separated from the other errors. Basically it means that a value could not be found although there is nothing wrong with that formula.
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org