The ISNUMBER, ISTEXT, ISBLANK guide
ISNUMBER(B2), ISTEXT(B2) and ISBLANK(B2) each return TRUE or FALSE for what the cell holds. A number typed with an apostrophe in front is text, and a 0 is a number, not an empty cell.
What each one says
| Holds | ISNUMBER | ISTEXT | ISBLANK |
|---|---|---|---|
| 42.5 | TRUE | FALSE | FALSE |
| 0 | TRUE | FALSE | FALSE |
| '18 | FALSE | TRUE | FALSE |
| n/a | FALSE | TRUE | FALSE |
| nothing | FALSE | FALSE | TRUE |
="" | FALSE | TRUE | FALSE |
'18 is 18 typed with an apostrophe in front, which stores it as text. ="" is a formula that shows nothing.
The IS functions don't convert anything: ISNUMBER("19") is FALSE. That's what makes them useful for finding the cells that SUM will skip.
Why not just compare?
=B2>0 looks like a test for "is a number", but Excel ranks all text above all numbers, so it is TRUE for "n/a" too. =B2=0 is TRUE for a 0 and for an empty cell. ISNUMBER and ISBLANK tell those apart.
ISBLANK and formulas
ISBLANK is TRUE only for a truly empty cell. A formula that returns "" looks empty but isn't, so ISBLANK says FALSE. To test "looks empty", use =B2="". More on this in Count the blanks.
Two common uses
- Contains a word:
=ISNUMBER(SEARCH("refund", B2)). SEARCH returns a position or an error; ISNUMBER turns that into TRUE or FALSE. - Flag rows to fix:
=IF(ISNUMBER(B2), "", "Check")marks every amount that won't add up.
FAQ
- What does ISNUMBER do in Excel?
- It returns TRUE when the value is a number and FALSE for anything else, including numbers stored as text.
- Why does ISBLANK return FALSE for a cell that looks empty?
- The cell holds something: usually a formula that returns "", sometimes a space. ISBLANK is TRUE only for a cell with nothing in it. Use =A1="" to test for "looks empty".
- How do I check if a cell contains text in Excel?
- Use =ISTEXT(A1). To check whether it contains a certain word, use =ISNUMBER(SEARCH("word",A1)).
- Why is ISNUMBER FALSE for a number?
- The number is stored as text, often from an import or a leading apostrophe. It sits on the left of the cell.



































































