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