# Testname: Functions: ISERROR(undefinedname) results in TRUE
Document Owner: Oliver Craemer | Last document change: 28.02.2008 | Status of document: Standard
Valid for version: OpenOffice.org_3.0

### Test purpose:

Verify that the ISERROR function works correctly

### Known issues:

### Preconditions of test:

Functionnames are localized. In this test the english names are used. For non-english version please use the names used in your locale

### Test documents:

-

### Testcases:

ISERROR(undefinedname) results in TRUE | Status: Standard | -
Open new spreadsheet document In cell A1 enter '=ISERROR(undefined)' Verify that the cell shows 'TRUE' Save document to *.ods Close and reload the document Verify that cell A1 still shows 'TRUE' Close document
ISERROR(CHOOSE(0;"text1";"text2")) results in TRUE | Status: Standard | -
Open new spreadsheet document In cell A1 enter '= ISERROR(CHOOSE(0;"text1";"text2")) ' Verify that the cell shows 'TRUE' Save document to *.ods Close and reload the document Verify that cell A1 still shows 'TRUE' Close document
ISERROR(VLOOKUP("abc";undefinedname;2;0)) results in TRUE | Status: Standard | -
Open new spreadsheet document In cell A1 enter '=ISERROR(VLOOKUP("abc";undefinedname;2;0)) Verify that the cell shows 'TRUE' Save document to *.ods Close and reload the document Verify that cell A1 still shows 'TRUE' Close document
ISERROR(ISEVEN(SUM(undefinedname))) results in TRUE | Status: Standard | -
Open new spreadsheet document In cell A1 enter '=ISERROR(ISEVEN(SUM(undefinedname)))' Verify that the cell shows 'TRUE' Save document to *.ods Close and reload the document Verify that cell A1 still shows 'TRUE' Close document
ISERROR((12*34)+(56+INT(AVERAGE(undefinedname)))) results in TRUE | Status: Standard | -
Open new spreadsheet document In cell A1 enter '=ISERROR((12*34)+(56+INT(AVERAGE(undefinedname))))� Verify that the cell shows 'TRUE' Save document to *.ods Close and reload the document Verify that cell A1 still shows 'TRUE' Close document

### References:

-

### Acronyms:

-

## testcase specification history

Functions: ISERROR(undefinedname) results in TRUE
Date | Change | User
--- | --- | ---
28.02.2008 (18:17:14) | status updated | Oliver Craemer
28.02.2008 (18:16:57) | status updated | Oliver Craemer
28.02.2008 (18:16:42) | status updated | Oliver Craemer
28.02.2008 (18:16:28) | testcase details added | Oliver Craemer
28.02.2008 (18:12:34) | testcase added | Oliver Craemer
28.02.2008 (18:11:30) | testcase details updated | Oliver Craemer
28.02.2008 (18:07:21) | testcase details added | Oliver Craemer
28.02.2008 (18:06:14) | testcase added | Oliver Craemer
28.02.2008 (18:04:29) | testcase deleted | Oliver Craemer
28.02.2008 (18:03:58) | testcase details updated | Oliver Craemer
28.02.2008 (18:01:45) | testcase details added | Oliver Craemer
28.02.2008 (17:59:22) | testcase added | Oliver Craemer
28.02.2008 (17:58:47) | testcase details updated | Oliver Craemer
28.02.2008 (17:56:27) | testcase details updated | Oliver Craemer
28.02.2008 (17:54:41) | testcase details updated | Oliver Craemer
28.02.2008 (17:51:51) | testcase details added | Oliver Craemer
28.02.2008 (17:49:15) | testcase added | Oliver Craemer
28.02.2008 (17:48:36) | status updated | Oliver Craemer
28.02.2008 (17:48:20) | testcase details added | Oliver Craemer
28.02.2008 (17:46:15) | testcase added | Oliver Craemer
27.02.2008 (09:38:30) | status updated | Oliver Craemer
27.02.2008 | Testcase specification created | Oliver Craemer