# ISTEXT

Formulas / ISTEXT
Test if a cell contains a text value.
`ISTEXT(value)`
• value - required argument to test

## Examples

The ISTEXT function will return the text "apple" when used with the argument "apple". When the ISTEXT formula is used with this argument, it will detect the text value and return TRUE.

The ISTEXT function will return FALSE when used with the argument A1. This is because A1 is a reference to a cell and not a text value.

The ISTEXT function will return TRUE when used with the argument A1 & "hello". This is because the ampersand (&) is the concatenation operator in Sourcetable, so the string A1 & "hello" is a text value.

The ISTEXT function will return TRUE when used with the argument 10 & "apples". This is because 10 apples is a text value.

## Summary

The ISTEXT function tests a value and returns TRUE or FALSE depending on the outcome. This can be useful for locating errors in formulas when combined with the IF function.

• The ISTEXT function can be used to check if a cell contains a text value or numeric value entered as text. It returns TRUE if the cell contains a text value and FALSE if it contains any other value other than NULL or 0.

What is the ISTEXT function?
The ISTEXT function is a function in Sourcetable that returns TRUE if the value argument is a text value, and FALSE if the value argument is a reference to another value.
What values does the ISTEXT function accept?
The ISTEXT function accepts text values as its value argument.
What does the ISTEXT function return?
• The ISTEXT function returns TRUE if the value argument is a text value.
• The ISTEXT function returns FALSE if the value argument is a reference to another value.
When should I use the ISTEXT function?
The ISTEXT function is useful when you want to check if a value is a text value or a reference to another value.