T Function in Excel tests if a supplied value is text and if so, returns supplied text. If not T Function returns an empty string.
Syntax of T Function in Excel :
T( value )
Where,
- value – value that you want to test
Example of T Function in Excel
Formula
- Row number 2 takes up the number argument and returns NULL.
- Row number 3 takes up date argument and returns NULL.
- Row number 5 and 6 takes up Logical argument and returns NULL.
- Row number 4 and 7 takes up Text argument and returns the text.
Result
