Difference between revisions of "Manuals/calci/T"

From ZCubes Wiki
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...")
 
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''T(n)'''</div><br/>
 +
*<math>n </math>  is the value to test.
  
'''T'''(SomeValue)
 
  
where,
+
==Description==
 +
*This function gives  the text referred to by value.
 +
*In <math> T(n), 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.
  
'''SomeValue''' - is the value you want to test.
 
  
</div>
+
==Examples==
----
+
{| class="wikitable"
<div id="1SpaceContent" class="zcontent" align="left">
+
|+Spreadsheet
 
+
|-
Calci returns the text referred to by value.
+
! !! A !! B
 
+
|-
</div>
+
! 1
----
+
| Pollution || 178
<div id="7SpaceContent" class="zcontent" align="left">
+
|-
 
+
! 2
If value does not refer to text, T returns "" (empty text).
+
| FALSE || 1B
 
 
</div>
 
----
 
<div id="9SpaceContent" class="zcontent" align="left">
 
 
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
| class=" " |
 
| Column1
 
| Column2
 
| Column3
 
| Column4
 
|- class="odd"
 
| class=" " | Row1
 
| class="sshl_f " | smith
 
| class="sshl_f" | smith
 
| 4
 
| class="sshl_f" | 5
 
|- class="even"
 
| class="  " | Row2
 
| class="    " | 7
 
| class="sshl_f  SelectTD ChangeBGColor SelectTD" |
 
<div id="9Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="9Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="9Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]</div>8
 
| class="sshl_f" | 7
 
| class="sshl_f" | 128
 
|- class="odd"
 
| Row3
 
| class=" " | 12
 
| class="sshl_f" | 67968
 
| class=" " | 14
 
| class="sshl_f    " | 15
 
|- class="even"
 
| Row4
 
| class=" " | 17
 
| class=" " | 18
 
| class="sshl_f" | 10000
 
| class="  " | 20
 
|- class="odd"
 
| class=" " | Row5
 
| 36
 
| 67994
 
| 10025
 
| 168
 
|- class="even"
 
| Row6
 
| NaN
 
| 0.850904
 
| 1.619775
 
| 0.525322
 
 
|}
 
|}
  
<div align="left"></div>''''''</div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
 
T
 
 
T
 
 
</div></div>
 
----
 
<div id="8SpaceContent" class="zcontent" align="left">
 
 
Lets see an example in (Column2,Row1)
 
 
<nowiki>=T(B2)</nowiki>
 
  
T returns the text.
+
#=T(A1) = Pollution
 +
#=T(B1) =
 +
#=T(A2) =
 +
#=T("Population") = Population
 +
#=T("201") = 201
 +
#=T(B2) = 1B
  
Consider another example
 
  
<nowiki>=T(9)</nowiki>
+
==See Also==
 +
*[[Manuals/calci/N  | N ]]
 +
*[[Manuals/calci/VALUE  | VALUE ]]
  
T returns  ""(empty string).
 
  
</div>
+
==References==
----
 
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
----
 
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
----
 
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
----
 
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
----
 

Revision as of 00:53, 3 February 2014

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