How to use the NONTEXT Function in Microsoft Excel

In this article, we will learn the function ISNONTEXT in Excel.

ISNONTEXT function returns FALSE if the value is TEXT and it returns TRUE if not. The function returns TRUE for blank cells and formula which returns non- text value like a number, a date, a time and TEXT values.

ISNONTEXT function checks the value cell for a TEXT value and returns FALSE if exist or else TRUE.
Syntax:

=ISNONTEXT ( value )

value : value to the function can be given as directly or using cell reference

Now let’s understand the function more via using it in an example.

Here we have a list of value in Column A & we need to check the cells for the TEXT values.

Use the formula:

= ISNONTEXT ( A2 )

A2 : reference cell is provided to the function to check its value.
And now the result of A3 cell.

You can observe the difference in output from the above snapshots between the LOGIC value in quotes and the one without quotes.

Copy the formula to other cells using the Ctrl + D shortcut key.

As you can see, the function returns the logic values either TRUE or FALSE. Below are some of the observational results.

Note:

  1. When range of cells given in as argument, the function only checks the first cell of the array as returns TRUE or FALSE based only on the first cell.
  2. The function returns FALSE for logical value but returns TRUE if the same value is in qotes.

Hope you understood how to use ISNONTEXT function in Excel 2016. Find more articles on Excel ISNONTEXT function here. Please share your query below in the comment box. We will assist you.

Related Articles
How to use the ISEVEN function in Excel
How to Use ISERROR Function in Excel
How to Use ISNUMBER Function in Excel
How to use the ISNA Function
How to use the ISTEXT Function in Excel
How to use the ISODD Function in Excel

Popular Articles
Edit a dropdown list
Absolute reference in Excel
If with conditional formatting
If with wildcards
Vlookup by date

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube