﻿ Information Functions

# 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