Changes

Manuals/calci/IS FUNCTIONS (view source)

Revision as of 11:04, 11 December 2013

302 bytes added , 11:04, 11 December 2013

→‎Description

Line 10: Line 10:

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

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

+

**n refers to an empty cell.

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

+

**n refers to any error value except #N/A.

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

+

**n refers to any error value

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

+

**n refers to a logical value.

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

+

**n refers to the NaN error value.

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

+

**n refers to any item that is not text.

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

+

**n refers to a reference.

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

+

**n refers to text.

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

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

Line 24: Line 32:

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

−

+

*where <math>n</math> is value to check with the function.

−

*where n is value to check with the function.

+

The <math>n</math> 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.

+

*This function will give the result as either TRUE or FALSE according to the <math>n</math> value.

−

*This function will give the result as either TRUE or FALSE according to the n value.

*This function will not convert any numbers from text.

*For e.g. "20" is normally converted as a number 20. But in ISNUMBER("20") will return FALSE, because "20" will not convert in to number.

Abin

writer

5,435

edits

Changes

Manuals/calci/IS FUNCTIONS (view source)

Revision as of 11:04, 11 December 2013

Navigation menu

Search