Exceljet

Quick, clean, and to the point

Excel ISNUMBER Function

Excel ISNUMBER function
Summary 

The Excel ISNUMBER function returns TRUE when a cell contains a number, and FALSE if not. You can use ISNUMBER to check that a cell contains a numeric value, or that the result of another function is a number.

Purpose 
Test for numeric value
Return value 
A logical value (TRUE or FALSE)
Syntax 
=ISNUMBER (value)
Arguments 
  • value - The value to check.
Usage notes 

Use the ISNUMBER function to check if a value is a number. ISNUMBER will return TRUE when value is numeric and FALSE when not.

For example, =ISNUMBER(A1) will return TRUE if A1 contains a number or a formula that returns a numeric value. If A1 contains text, ISNUMBER will return FALSE.

Notes

  • Typically, value is supplied as a cell address, but you can wrap other functions and formulas inside ISNUMBER to test the result.
  • ISNUMBER will return TRUE for Excel dates and times since they are numeric, and FALSE for numbers entered as text.
  • ISNUMBER is part of a group of functions called the IS functions.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.