Examples for the t formula
Copy these examples into a spreadsheet and adjust the ranges for your own data.
T syntax pattern
=T(v)Use this T pattern as the starting point for your spreadsheet formula.
T in a worksheet
=T(v)Returns a string value unmodified, or an empty string for non-string values.
When to use T
Use T when you need to return a string value unmodified, or an empty string for non-string values.
- Clean, reshape, and compare text values.
- Prepare labels, IDs, and imported text for analysis.
How T works in Quadratic
In Quadratic, T follows the syntax T(v). The function works inside Quadratic formulas and can be combined with spreadsheet ranges, tables, and other formulas.
Common T mistakes
Most T issues come from mismatched argument types, ranges that do not cover the intended data, or optional parameters being omitted when the default behavior is not what you expected.
- Check each required parameter before copying the formula across a sheet.
- Confirm that ranges line up with the rows or columns you intend to analyze.
- Use Quadratic AI to explain or debug the formula when the result looks wrong.