Difference between revisions of "Manuals/calci/T"

From ZCubes Wiki
Jump to navigation Jump to search
 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
<div style="font-size:30px">'''T(n)'''</div><br/>
 
<div style="font-size:30px">'''T(n)'''</div><br/>
 
*<math>n </math>  is the value to test.
 
*<math>n </math>  is the value to test.
 
  
 
==Description==
 
==Description==
 
*This function gives  the text referred to by value.  
 
*This function gives  the text referred to by value.  
*In <math> T(n), n </math> is the value to test .  
+
*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.
 
*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==
 
==Examples==
Line 21: Line 19:
 
| FALSE || 1B  
 
| FALSE || 1B  
 
|}
 
|}
 
  
 
#=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==
 
*[[Manuals/calci/N  | N ]]
 
*[[Manuals/calci/N  | N ]]
 
*[[Manuals/calci/VALUE  | VALUE ]]
 
*[[Manuals/calci/VALUE  | VALUE ]]
 
  
 
==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.

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

Spreadsheet
A B
1 Pollution 178
2 FALSE 1B
  1. =T(A1) = Pollution
  2. =T(B1) = 178
  3. =T(A2) = FALSE
  4. =T("Population") = Population
  5. =T("201") = 201
  6. =T(B2) = 1B

Related Videos

Test

See Also

References