Share this article:

What it does: The ISNUMBER() function checks to see whether the given argument is a number.

Plain English: The ISNUMBER literally tests to see if a given value is a number. The function is very useful to test the results of other functions whose results may or may not be numbers. For instance, FIND(), MATCH(), SEARCH(), and many other excel functions can return a numeric value. Often times, what is more important is not so much the number spat out of these equations, but whether or not they return a number at all.

Arguments: ISNUMBER(value)

  • Value – The value you want to check. The result is a Boolean value – either TRUE or FALSE.