Returns the logical value TRUE
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.
no required arguments and
no optional arguments:
Getting TRUE whether you want it or not:
Thanks, but no thanks. I don't want the logical TRUE value, just the text please:
TRUE is a simple function that is obscure to most users.