I wanted to take some time today to review an often overlooked function.
The T function checks the value in a cell and if the value is text, it returns the text value. If it is not a text value, the T function returns double quotes (empty text).
There is only one argument in the T function (the cell reference) =T(cell reference).
In the below example I have in column A different types of formats (text, percentages, numbers and dates). I have placed the T function in column C and you can clearly see how this works.
| | A | C | D | E |
| 1 | Item | Result | Formula | Explanation |
| 2 | one | one | =T(A2) | this is a text so the result is the text value in cell A2 |
| 3 | 15% | =T(A3) | this is a percent so the result is double quotes | |
| 4 | three | three | =T(A4) | this is a text so the result is the text value in cell A4 |
| 5 | 4 | =T(A5) | this is a number so the result is double quotes | |
| 6 | 6/15/2012 | =T(A6) | this is a date so the result is double quotes |
So what can the T function do for you?
No comments:
Post a Comment