ISNONTEXT

Formulas / ISNONTEXT
Test for a non-text value.
=ISNONTEXT(value)
  • value - the expression or value to test (required)

Examples

  • ISNONTEXT(100)

    The Sourcetable function returns TRUE because 100 is a number. The ISNONTEXT function checks if the provided argument is a value type of text. Since 100 is a number, it is not a text value and therefore the function returns TRUE.

  • ISNONTEXT("apple")

    The Sourcetable function returns FALSE because "apple" is a text value. Since the argument is a string of text, the function returns FALSE.

  • ISNONTEXT(A1)

    The Sourcetable function returns TRUE if A1 does not contain text.

  • ISNONTEXT(A1)

    The Sourcetable function returns FALSE if A1 does contain text.


Summary

ISNONTEXT is a function used to determine if a given value is a text value or not. If the value is a text value the function will return TRUE.

  • ISNONTEXT returns TRUE if a cell contains any value other than text, and takes one argument, 'value', which can be a cell reference, a formula, or a value hardcoded in the function.

Frequently Asked Questions

What is the ISNONTEXT function?
The ISNONTEXT function is a logical function in Sourcetable which returns TRUE if the value is not text.
Why is the ISNONTEXT function useful?
The ISNONTEXT function is useful for verifying the outcome of a calculation. It can also be useful for testing the outcome of a calculation with the IF function.
What are some examples of using the ISNONTEXT function?
  • To verify the outcome of a calculation is not text
  • To test the outcome of a calculation with the IF function

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV