Excel Function

ISNUMBER

Checks whether value is a number.

ISNUMBER(value)

Arguments

value

Required

Specify a single cell reference.

Practice Preview

show value type/status checks. Use ISNUMBER to Checks whether value is a number. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=ISNUMBER(B2)

Practice This Function