## Information functions: isnontext, isnumber, isref, istext, n

#### Excel Function ISNONTEXT

The ISNONTEXT() function is used to determine if the given value is nontext or not.

This function returns TRUE if the value is a nontext and FALSE, otherwise.

The syntax of this function is as given below:

ISNONTEXT(value or expression)

 ISNONTEXT() Formula True =ISNONTEXT(2) False =ISNONTEXT("KK") True =ISNONTEXT(gg) False =ISNONTEXT(M4)

#### Excel Function ISNUMBER

The ISNUMBER() function is used to determine if the given value is number or not.

This function returns TRUE if the value is a number and FALSE, otherwise.

The syntax of this function is as given below:

ISNUMBER(value or expression)

 ISNUMBER() Formula True =ISNUMBER(34) False =ISNUMBER("34") False =ISNUMBER(M15) True =ISNUMBER(0.1)

#### Excel Function ISREF

The ISREF() function is used to determine, if the given argument is a reference or not.

This function returns TRUE, if reference and FALSE, otherwise.

The syntax of this function is as given below:

ISREF(value)

 ISREF() Formula True =ISREF(M27) False =ISREF(34) True =ISREF('Q11'!B7) False =ISREF("REF")

#### Excel Function ISTEXT

The ISTEXT() function is used to determine if the given value is text or not.

This function returns TRUE if the value is a text and FALSE, otherwise.

The syntax of this function is as given below:

ISTEXT(value or expression)

 ISTEXT() Formula True =ISTEXT(M38) False =ISTEXT(22) True =ISTEXT("22") False =ISTEXT(N41)

#### Excel Function N

The N() function is used to convert a data into a numeric value.

This text or strings are converted to 0.

The numeric value remains the same.

The logical TRUE is converted to 1 and FALSE is converted to 0.

 N Formula 8 =N(8) 0 =N("8") 1 =N(TRUE) 0 =N(FALSE)