Module information 

Information formula functions: ISERR, ISNA, ISLOGICAL, ISEVEN, ISODD, TYPE, N, NA, ERROR.TYPE.

Functions

fn_error_type

ERROR.TYPE(value) - returns error type code. 1=#NULL!, 2=#DIV/0!, 3=#VALUE!, 4=#REF!, 5=#NAME?, 6=#NUM!, 7=#N/A. Returns #N/A if value is not an error.

fn_iserr

ISERR(value) - TRUE if value is an error other than #N/A

fn_iseven

ISEVEN(number) - TRUE if the integer part of number is even

fn_islogical

ISLOGICAL(value) - TRUE if value is a boolean

fn_isna

ISNA(value) - TRUE if value is #N/A

fn_isodd

ISODD(number) - TRUE if the integer part of number is odd

fn_n

N(value) - convert to number: numbers stay, bools become 0/1, errors stay, everything else 0

fn_na

NA() - returns #N/A error

fn_type

TYPE(value) - returns type code: 1=number, 2=text, 4=boolean, 16=error, 64=array