ISNONTEXT

Tests if a cell contains no text.

Syntax:

ISNONTEXT(value)

Returns TRUE unless value is or refers to text, in which case it returns FALSE.

ISNONTEXT(value) is equivalent to NOT(ISTEXT(value)).

Example:

ISNONTEXT(123)

returns TRUE.

ISNONTEXT(C2)

where cell C2 contains cat, returns FALSE.

ISNONTEXT(C3)

where cell C3 contains =1/0, returns TRUE, because =1/0 returns an error value, not text.

Application:

Inventory Management

Imagine you are managing the inventory for a small electronics store. You have a spreadsheet to track your products. You want to quickly identify rows that have an error in the "Quantity on Hand" column. A common data entry error is accidentally typing a word (like "N/A" or "Check") instead of a number. You can use ISNONTEXT to flag these rows.

Here is a table representing your inventory data:

	Product ID	Product Name	Category	Quantity on Hand
	A	B	C	D
1	1001	Laptop	Computers	5
2	1002	Smartphone	Mobile Devices	12
3	1003	Monitor	Peripherals	N/A
4	1004	Keyboard	Peripherals	8
5	1005	Mouse	Peripherals	Check
6	1006	Tablet	Mobile Devices	7
7	1007	Printer	Peripherals	0
8	1008	Camera	Cameras	3

Now, you can add a new column called "Is Quantity Valid?" and use the ISNONTEXT function to check if the value in the "Quantity on Hand" column is a number (or a non-text value).

The formula you would use in the "Is Quantity Valid?" column (let's say this is column E) would be: ISNONTEXT(D1) and then you would enter this formula for the rest of the rows.

Here's what the resulting table would look like:

	Product ID	Product Name	Category	Quantity on Hand	Is Quantity Valid?
	A	B	C	D	E
1	1001	Laptop	Computers	5	TRUE
2	1002	Smartphone	Mobile Devices	12	TRUE
3	1003	Monitor	Peripherals	N/A	FALSE
4	1004	Keyboard	Peripherals	8	TRUE
5	1005	Mouse	Peripherals	Check	FALSE
6	1006	Tablet	Mobile Devices	7	TRUE
7	1007	Printer	Peripherals	0	TRUE
8	1008	Camera	Cameras	3	TRUE

Explanation:

For products with a valid numerical quantity (e.g., Laptop, Smartphone), the ISNONTEXT function returns TRUE because the cell contains a number, which is not text.
For Monitor and Mouse, the cells contain the text "N/A" and "Check" respectively. Since these are text values, the ISNONTEXT function returns FALSE.