Typically,valueis entered as a cell reference like A1.

Whenvalueis a number, the ISNUMBER function will return TRUE.

Otherwise, ISNUMBER will return FALSE.

Excel formula: Sum if cell contains text in another cell

When values are concatenated, the result is text.

For example, if A1 contains “apple”, ISBLANK(A1) returns FALSE.

ISEVEN will return the #VALUE error if a value is not numeric.

Excel formula: Cell contains one of many with exclusions

When a cell contains a formula ISFORMULA will return TRUE regardless of the formula’s output or error conditions.

ISNONTEXT Function

The Excel ISNONTEXT function returns TRUE when a cell contains any value except text.

This includes numbers, dates, times, errors, and formulas that do not return text.

Excel formula: Get first match cell contains

ISNONTEXT also returns TRUE when a cell is empty.

ISODD will return the #VALUE error if a value is not numeric.

ISREF Function

The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not.

Excel formula: If cell contains one of many things

you’re able to use the ISREF function to check for a reference in a formula.

Excel formula: Categorize text with keywords

Excel formula: Range contains one of many values

Excel formula: Filter contains one of many

Excel formula: Value exists in a range

Excel formula: LAMBDA contains one of many

Excel formula: Count cells that contain specific text

Excel formula: Data validation require unique number

Excel formula: Extract common values from two lists

Excel formula: Get all matches cell contains

Excel formula: Find missing values

Excel formula: FILTER with multiple OR criteria

Article image

Excel ISBLANK function

Excel ISERR function

Excel ISERROR function

Excel ISEVEN function

Excel ISFORMULA function

Excel ISLOGICAL function

Excel ISNA function

Excel ISNONTEXT function

Excel ISODD function

Excel ISREF function

Excel ISTEXT function