Difference between revisions of "Manuals/calci/T"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''T'''(SomeValue) where, '''SomeValue''' - is the value you want to test. </div> ---- <div id="1SpaceCont...") |
|||
| (4 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''T(n)'''</div><br/> |
| + | *<math>n </math> is the value to test. | ||
| − | + | ==Description== | |
| + | *This function gives the text referred to by value. | ||
| + | *In <math> T(n)</math>, <math>n </math> is the value to test . | ||
| + | *This function will return the same text whether <math> n </math> value is text or it will return the empty text whether <math> n </math> value is not text. | ||
| − | + | ==Examples== | |
| − | + | {| class="wikitable" | |
| − | + | |+Spreadsheet | |
| − | + | |- | |
| − | + | ! !! A !! B | |
| − | + | |- | |
| − | + | ! 1 | |
| − | + | | Pollution || 178 | |
| − | + | |- | |
| − | + | ! 2 | |
| − | + | | FALSE || 1B | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | { | ||
| − | |||
| − | | class=" " | ||
| − | |||
| − | |||
| − | | | ||
| − | |||
| − | |- | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |- | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
| − | | | ||
| − | |- | ||
| − | |||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
|} | |} | ||
| − | + | #=T(A1) = Pollution | |
| − | + | #=T(B1) = 178 | |
| − | + | #=T(A2) = FALSE | |
| − | + | #=T("Population") = Population | |
| − | T | + | #=T("201") = 201 |
| − | + | #=T(B2) = 1B | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | ==Related Videos== | |
| − | + | {{#ev:youtube|BlS11D2VL_U|280|center|Test}} | |
| − | + | ==See Also== | |
| + | *[[Manuals/calci/N | N ]] | ||
| + | *[[Manuals/calci/VALUE | VALUE ]] | ||
| − | + | ==References== | |
| − | + | *[http://www.techonthenet.com/excel/formulas/t.php Text referred to by a value] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 00:35, 26 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