IsNumeric(expression)

Category: Logical function

This function returns TRUE if the result of expression is a number or text that looks like a number. Otherwise, it returns FALSE.

Return value type: Boolean (TRUE/FALSE)

isnumeric(123) //Returns TRUE

isnumeric('456') //Returns TRUE

isnumeric('100' & '20') //Returns TRUE (the result '10020' appears as a number)

isnumeric('This is a number!') //Returns FALSE

isnumeric('100A') //Returns FALSE

• IsBoolean(expression)
• IsEmpty(expression)
• IsError(expression)
• IsInteger(expression)
• IsNumber(expression)
• IsText(expression)