Checks if a value is not text and returns TRUE or FALSE.
ไวยากรณ์
ISNONTEXT(value)อาร์กิวเมนต์
valueจำเป็น
The value you want to test.
The ISNONTEXT function determines whether a given value is anything other than text. It returns TRUE if the value refers to a number, logical value, error, or blank cell, and FALSE if the value is text.
=ISNONTEXT("Excel")→FALSESince "Excel" is a text string, the function returns FALSE.
=ISNONTEXT(123)→TRUESince 123 is a number, the function returns TRUE.
Select the cell
Click on the cell where you want to display the result.
Enter the formula
Type =ISNONTEXT(value) and replace 'value' with the cell reference or data you want to check.
Press Enter
Press Enter to see the logical result.
Yes, ISNONTEXT returns TRUE for blank cells because they are not considered text.