ISNUMBER function - The function returns True if the value is numeric in Excel

The following article introduces you to the ISNUMBER function - one of the functions in the information function group is very popular in Excel.

ISNUMBER function - The function returns True if the value is numeric in Excel Picture 1

Description: The function returns True if the value is numeric. Use the function to check if the value is numeric or not.

Syntax: ISNUMBER (value)

Inside:

- value: The value you want to check is a numeric value or not, is a required parameter.

Attention:

- The function returns True if the value is a numeric value and vice versa, the function returns False.

- Where value is a logical value or a blank value -> the function returns False value .

For example:

Determine whether the values ​​in the value are numerical or not.

ISNUMBER function - The function returns True if the value is numeric in Excel Picture 2

- In the cell to calculate enter the formula : = ISNUMBER (C6)

ISNUMBER function - The function returns True if the value is numeric in Excel Picture 3

- Press Enter -> return value is:

ISNUMBER function - The function returns True if the value is numeric in Excel Picture 4

- Here cell C6 is a numeric value, not a text value, so the function returns True.

- Similarly copying the formula for the remaining values ​​results:

ISNUMBER function - The function returns True if the value is numeric in Excel Picture 5

- Where value is a logical value or a blank value -> the function returns False value .

ISNUMBER function - The function returns True if the value is numeric in Excel Picture 6

Above are instructions and some specific examples when using the ISNUMBER function in Excel.

Good luck!