Excel Made Easy

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)

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)

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)

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)

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.

You can find similar Excel Questions and Answer hereunder

1) Vlookup to return max value from multiple hits in Excel

2) Userform initialize vs userform show in Excel

3) information functions na na type isformula

4) Highlight row of selected cell in Excel

5) Vba delete entire row if contains certain text in Excel

6) Vba clear the contents of an entire sheet in Excel

7) Converting numbers stored as text to numbers via macro in Excel

8) Conditional formatting with if statement in Excel

9) Write to text file without quotes in vba in Excel

10) Converting numbers stored as text to numbers via macro in Excel