Changes

*These functions are simple data validation and data type checking functions.

*These functions are simple data validation and data type checking functions.

The ISFUNCTIONS are listed below:

The ISFUNCTIONS are listed below:

ISARRAY(n)

*[[Manuals/calci/ISARRAY| ISARRAY(n)]]

ISLEAPYEAR(n)

*[[Manuals/calci/ISLEAPYEAR| ISLEAPYEAR(n)]]

ISBLANK(n)

*[[Manuals/calci/ISBLANK| ISBLANK(n)]]

ISERR(n)

*[[Manuals/calci/ISERR| ISERR(n)]]

ISERROR(n)

*[[Manuals/calci/ISERROR| ISERROR(n)]]

ISLOGICAL(n)

*[[Manuals/calci/ISLOGICAL| ISLOGICAL(n)]]

ISNA(n)

*[[Manuals/calci/ISNA| ISNA(n)]]

ISNONTEXT(n)

*[[Manuals/calci/ISNONTEXT| ISNONTEXT(n)]]

ISREF(n)

*[[Manuals/calci/ISREF| ISREF(n)]]

ISTEXT(n)

*[[Manuals/calci/ISTEXT| ISTEXT(n)]]

ISPMT(n)

*[[Manuals/calci/ISPMT| ISPMT(n)]]

ISEMPTY(n)

*[[Manuals/calci/ISEMPTY| ISEMPTY(n)]]

ISNULL(n)

*[[Manuals/calci/ISNULL| ISNULL(n)]]

ISEVEN(n)

*[[Manuals/calci/ISEVEN| ISEVEN(n)]]

ISODD(n)

*[[Manuals/calci/ISODD| ISODD(n)]]

ISPRIME(n)

*[[Manuals/calci/ISPRIME| ISPRIME(n)]]

 

 

*where n is value to check with the  function.

*where n is value to check with the  function.

The n can be any type like empty cell, Boolean values,text,non text,number,reference-value or name referring to any of these.

The n can be any type like empty cell, Boolean values,text,non text,number,reference-value or name referring to any of these.