Formulas > =T()

How To Use T() Function in Google Sheets


Returns string arguments as text.

Common questions about the T formula include: What is the purpose of the T formula? How do you write the T formula in Google Sheets? What does the T formula do?

The T formula can be used appropriately to determine whether two ranges in a worksheet contain the same values.

The T formula can be commonly mistyped as the ""TExact"" or ""TEQUAL"" formulas, which return an error if used. 

Some common ways the T formula is used inappropriately include using it on text strings, or comparing non-numerical values, as the T formula only works on numerical values. 

Common pitfalls when using the T formula include not properly understanding the exact purpose of the formula and/or misreading the range of cells needed for it to be used.

Common mistakes when using the T Formula include using it on the incorrect number of cells, using it on cells with non-numerical values, and forgetting to use absolute references. 

Common misconceptions people might have with the T Formula include thinking that it works with text strings, or that it will automatically adjust if the data changes.

How To Actually Use T() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the T() formula:

T function in excel

This video shows you how to verify number and text using excel formula. T function helps for the same.

Generate a T() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.