Difference between revisions of "Manuals/calci/T"

From ZCubes Wiki
Jump to navigation Jump to search
Line 32: Line 32:
  
 
==References==
 
==References==
 +
*[http://www.techonthenet.com/excel/formulas/t.php Text referred to by a value]

Revision as of 14:31, 14 May 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) =
  3. =T(A2) =
  4. =T("Population") = Population
  5. =T("201") = 201
  6. =T(B2) = 1B

See Also

References