The ISNONTEXT function in Microsoft Excel is an data function and its function is to return TRUE if the worth shouldn’t be textual content. The method for the ISNONTEXT function is ISNONTEXT (worth). The syntax for the ISNONTEXT function is:
- Worth: the worth you need to take a look at.
What’s the ISNONTEXT method in Excel?
The ISNONTEXT function 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.
How to use ISNONTEXT function in Excel
To use the ISNONTEXT function in Excel, observe the steps under.
- Launch Microsoft Excel
- Create a desk or use an current desk out of your information
- Place the method into the cell you need to see the outcome
- Press the Enter Key.
Launch Microsoft Excel.
Create a desk or use an current desk out of your information.
Sort the method into the cell you need to place the outcome =ISNONTEXT(A2).
Then press the Enter key to see the outcome.
If in case you have multiple information in the desk, you possibly can click on the outcome and drag the fill deal with down to see extra outcomes.
You’ll discover in the picture above the ISNONTEXT function 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 could be a non-text.
There are two different strategies to use the ISNONTEXT function.
Methodology one is to click on the fx button on the highest left of the Excel worksheet.
An Insert Function dialog field will seem.
Contained in the dialog field in the part, Choose a Class, choose Info from the checklist field.
Within the part Choose a Function, select the ISNONTEXT function from the checklist.
Then click on OK.
A Function 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 capabilities button in the Function Library group.
Then choose Info then choose ISNONTEXT from the checklist.
A Function Arguments dialog field will seem.
We hope this tutorial helps you perceive how to use the ISNONTEXT function in Microsoft Excel; when you have questions concerning the tutorial, tell us in the feedback.
