The TRUE function is a simple but somewhat obscure function that is primarily for compatibility with other spreadsheet programs. You can also type the text "true" or "TRUE" directly onto the worksheet or into the formula, and Excel interprets it as the logical value TRUE.

TRUE takes no required arguments and no optional arguments:

Syntax: TRUE()

#1)
Using the TRUE function:
#2)
Getting TRUE whether you want it or not:
#3)
Thanks, but no thanks. I don't want the logical TRUE value, just the text please:

Summary

TRUE is a simple function that is obscure to most users.
comments powered by Disqus