Difference between revisions of "Manuals/calci/T"
Jump to navigation
Jump to search
| (2 intermediate revisions by 2 users not shown) | |||
| Line 21: | Line 21: | ||
#=T(A1) = Pollution | #=T(A1) = Pollution | ||
| − | #=T(B1) = | + | #=T(B1) = 178 |
| − | #=T(A2) = | + | #=T(A2) = FALSE |
#=T("Population") = Population | #=T("Population") = Population | ||
#=T("201") = 201 | #=T("201") = 201 | ||
#=T(B2) = 1B | #=T(B2) = 1B | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|BlS11D2VL_U|280|center|Test}} | ||
==See Also== | ==See Also== | ||
| Line 32: | Line 36: | ||
==References== | ==References== | ||
| + | *[http://www.techonthenet.com/excel/formulas/t.php Text referred to by a value] | ||
Latest revision as of 23:35, 25 October 2015
T(n)
- is the value to test.
is the value to test.Description
- This function gives the text referred to by value.
- In , is the value to test .
- This function will return the same text whether value is text or it will return the empty text whether value is not text.
, Examples
| A | B | |
|---|---|---|
| 1 | Pollution | 178 |
| 2 | FALSE | 1B |
- =T(A1) = Pollution
- =T(B1) = 178
- =T(A2) = FALSE
- =T("Population") = Population
- =T("201") = 201
- =T(B2) = 1B