writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">+ − Syntax+ − </div></div>+ − ---- − <div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify"> − Examples+ + − + − ----+ − <div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>+ − ---- − <div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify"> − <font size="5">Description</font>+ − + − </div></div>+ − ----+ − <div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> + − + − <font color="#484848"><font face="Arial, sans-serif"><font size="2">This function gives the type of value. </font></font></font>+ − + − </div></div>+ − ----+ − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="6">TYPE</font></div></div>+ − ----+ − <div id="6SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> + − + − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''TYPE'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''V'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">if V is type that shows</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">Number 1</font></font></font> − <font color="#484848"><font face="Arial, sans-serif"><font size="2">Text 2</font></font></font>+ − <font color="#484848"><font face="Arial, sans-serif"><font size="2">Logical value 4</font></font></font>+ − <font color="#484848"><font face="Arial, sans-serif"><font size="2">Error value 16</font></font></font>+ − <br /><br />+ − − </div></div> − ---- − − | class=" " |+ − | Column1 − | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − − | class="sshl_f" | 2 − | class="sshl_f " | 20 − | class="sshl_f" | 1 − |- class="even" − | class=" " | Row2 − | class=" " | − | class=" " | + − | Row3+ − − <div id="1Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="1Space_Copy" title="Click and Drag over to AutoFill other cells."></div> − | class=" " | + − | Row4+ − | class=" " | − + − + − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | Row6 − | class=" " | − | class=" " | + − <div align="left">[[Image:calci1.gif]]</div></div>+ − ----+ − <div id="4SpaceContent" class="zcontent" align="left"> + − + − <font color="#484848"><font face="Arial, sans-serif"><font size="2">Let's see an example </font></font></font>+ − + − <font color="#484848"><font face="Arial, sans-serif"><font size="2">Let B2 = Peter</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e.=TYPE(B2) is 2</font></font></font> − <font color="#484848"><font face="Arial, sans-serif"><font size="2">Let D2 =20</font></font></font>+ − <font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e.=TYPE(D2) is 1</font></font></font>+ − <br /><br />+ − </div>+ − ----
no edit summary
=TYPE(SomeInputValue)=
*where, <math>SomeInputValue</math> is an input value.
TYPE() displays the type of input value.
== Description ==
TYPE(SomeInputValue)
</div></div>
*TYPE() function can be used when the behavior of some function depends on the type of particular input value.
*Argument <math>SomeInputValue</math> can be a number, text, a logical value, array etc.
*Below table shows the 'Return Type' with respect to the values:
{| class="wikitable"
|-
! VALUE !! RETURN TYPE
|-
| Number || 1
|-
| Text || 2
|-
| Logical Value || 4
|-
| Error Value || 16
|-
| Array || 64
|}
*If value of a cell reference is a formula, TYPE() displays the type of the formula's resulting value.
== Examples ==
Consider the following example in Calci that shows the use of TYPE function:
<div id="2SpaceContent" class="zcontent" align="left">
<div id="1SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class="sshl_f" | 3200
| class="sshl_f " | PETER
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
|- class="odd"
| class="sshl_f" | 8/19/2010
| class=" SelectTD" |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
|- class="even"
| class="sshl_f" | Welcome
| class=" " |
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
|- class="odd"
| class=" " | Row5
| class="sshl_f" | TRUE
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|}
|}
=TYPE(A1) : Returns the type for number value. Displays '''1''' as a result.
=TYPE(A2) : Returns the type for number value. Displays '''1''' as a result.
=TYPE(A3) : Returns the type for a text value. Displays '''2''' as a result.
=TYPE(A4) : Returns the type for a logical value. Displays '''4''' as a result.
=TYPE(A1+100) : Returns the type for resulting number value from a formula. Displays '''1''' as a result.
=TYPE([1,2;3,4]) : Returns the type for an array value. Displays '''64''' as a result.
== See Also ==
*[[Manuals/calci/TEXT | TEXT]]
== References ==
*[http://en.wikipedia.org/wiki/Data_types Data Types]