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

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.