The ISNONTEXT operate in Microsoft Excel is an info operate and its objective is to return TRUE if the worth is just not textual content. The formulation for the ISNONTEXT operate is
ISNONTEXT (worth). The syntax for the ISNONTEXT operate is:
- Worth: the worth you wish to take a look at.
What’s the ISNONTEXT formulation in Excel?
The ISNONTEXT operate will return a logical worth which is TRUE or FALSE. The ISNONTEXT worth returns TRUE for any non-text values together with, numbers date and time, and blanks.
The way to use ISNONTEXT operate in Excel
To make use of the ISNONTEXT operate in Excel, observe the steps beneath.
- Launch Microsoft Excel
- Create a desk or use an current desk out of your recordsdata
- Place the formulation into the cell you wish to see the outcome
- Press the Enter Key.
Launch Microsoft Excel.
Create a desk or use an current desk out of your recordsdata.
Sort the formulation into the cell you wish to place the outcome =ISNONTEXT(A2).
Then press the Enter key to see the outcome.
When you have multiple knowledge within the desk, you possibly can click on the outcome and drag the fill deal with right down to see extra outcomes.
You’ll discover within the picture above the ISNONTEXT operate returns FALSE for the textual content River as a result of it’s a textual content and TRUE for 3 as a result of it’s a quantity that may be a non-text.
There are two different strategies to make use of the ISNONTEXT operate.
Methodology one is to click on the fx button on the highest left of the Excel worksheet.
An Insert Operate dialog field will seem.
Contained in the dialog field within the part, Choose a Class, choose Data from the checklist field.
Within the part Choose a Operate, select the ISNONTEXT operate from the checklist.
Then click on OK.
A Operate Arguments dialog field will open.
Within the Worth entry field, enter into the entry field cell A2.
Then click on OK.
Methodology two is to click on the Formulation tab, click on the Extra features button within the Operate Library group.
Then choose Data then choose ISNONTEXT from the checklist.
A Operate Arguments dialog field will seem.
We hope this tutorial helps you perceive easy methods to use the ISNONTEXT operate in Microsoft Excel; when you’ve got questions concerning the tutorial, tell us within the feedback.