- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Information - ISNONTEXT Function
Description
The ISNONTEXT function returns the logical value TRUE if the specified value refers to any item that is not text. Otherwise returns FALSE. The function returns TRUE if the value refers to a blank cell.
Syntax
ISNONTEXT (value)
Arguments
| Argument | Description | Required/Optional |
|---|---|---|
| value | Value or expression or a reference to a cell. | Required |
Notes
You can use this function to test the contents of a cell before performing a calculation.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_information_functions.htm
Advertisements