Free Online Tutorials on Spreadsheets

T function in Excel

Purpose

The T function used to check whether the given value is a text or not. If the tested value is a text then the formula returns the same value, otherwise returns an empty text string.

Example

1– The T function mentioned hereunder tests different three values and returns results accordingly.

Result:

Syntax

+T(value)

where, (value) that you want to test.

Purpose of the T function

Latest versions of Excel, by default automatically converts values as necessary. The T function can be utilized for compatibility with other spreadsheet programs.




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved