ISNUMBER
Formulas / ISNUMBERTest if a cell contains a number.
=ISNUMBER(value)
- value - required argument, may be a blank cell, an error, a logical value, text, a number, or a reference value.
Examples
This example returns TRUE because 100 is a number.
This example returns TRUE because A1 contains 100.
This example returns TRUE because 2+2 is a number.
This example returns TRUE because 2^3 is a number.
Need help with Formulas?
Summary
The ISNUMBER function is a useful tool for determining if a cell in Sourcetable contains a number. It will return TRUE if the cell contains a number, or FALSE if it does not.
- The ISNUMBER function can be used to check if a cell contains a numeric value, or if the result of another function is a number. It returns TRUE if the cell contains a numeric value, or FALSE if it does not.
Frequently Asked Questions
What does the ISNUMBER function do?
The ISNUMBER function returns TRUE if the value argument is not a reference to an empty cell. It is useful for testing the outcome of a calculation, and it can be used with the IF function to locate errors in formulas.
Does ISNUMBER return TRUE if the argument is text?
Yes, ISNUMBER returns TRUE if the value argument is a text value.
Does ISNUMBER return FALSE if the argument is a number?
Yes, the ISNUMBER function returns FALSE if the value argument is a number.
What are some other uses for ISNUMBER?
The ISNUMBER function can be used in a variety of ways. Some uses include:
- Testing the outcome of a calculation
- Locating errors in formulas
- Identifying text values
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV