Information Functions

The functions that relate to information about a cell or the value in a cell are:

 

COUNTBLANK(cellrange)

COUNTBLANK(column)

This function returns the number of empty (or blank) cells in a column or a range of cells on a datasheet.

 

ERRORTYPE(errorvalue)

This function returns a number corresponding to one of the error values.

Error Value

Function Returns

#NULL!

1

#DIV/0!

2

#VALUE!

3

#REF!

4

#NAME?

5

#NUM!

6

#N/A

7

 

ISBLANK(expression)

This function tests whether a value, an expression, or contents of a referenced cell is empty.

 

ISERR(expression)

This function, Is Error Other Than Not Available, tests whether a value, an expression, or contents of a referenced cell has an error other than not available (#N/A).

 

ISERROR(expression)

This function, Is Error of Any Kind, tests whether a value, an expression, or contents of a referenced cell has an error of any kind.

 

ISEVEN(expression)

This function, Is Number Even, tests whether a value, an expression, or contents of a referenced cell is even.

 

ISLOGICAL(expression)

This function tests whether a value, an expression, or contents of a referenced cell is a logical (Boolean) value.

 

ISNA(expression)

This function, Is Not Available, tests whether a value, an expression, or contents of a referenced cell has the not available (#N/A) error value.

 

ISNONTEXT(expression)

This function tests whether a value, an expression, or contents of a referenced cell has any data type other than text.

 

ISNUMBER(expression)

This function tests whether a value, an expression, or contents of a referenced cell has numeric data.

 

ISODD(expression)

This function, Is Number Odd, tests whether a value, an expression, or contents of a referenced cell has numeric data.

 

ISREF(expression)

This function, Is Reference, tests whether a value, an expression, or contents of a referenced cell is a reference to another cell.

 

ISTEXT(expression)

This function tests whether a value, an expression, or contents of a referenced cell has text data.

 

N(value)

This function returns a value converted to a number.

 

NA( )

This function returns the error value #N/A that means ""not available.""

 

TYPE(value)

This function returns the type of value.

Type of Value    

Returned Number

Number

1

DateTime object

1

TimeSpan object

1

Text

2

Logical value

4

Error value

16

Array

64

 

 

 

See Also:


Formula Functions