Difference between revisions of "Manuals/calci/TYPE"

From ZCubes Wiki
Jump to navigation Jump to search
Line 1: Line 1:
=TYPE(SomeInputValue)=
 
 
<div style="font-size:30px">'''TYPE (InputValue) '''</div><br/>
 
<div style="font-size:30px">'''TYPE (InputValue) '''</div><br/>
 
*where, <math>InputValue</math> is an input value.  
 
*where, <math>InputValue</math> is an input value.  

Revision as of 16:54, 9 August 2018

TYPE (InputValue)


  • where, is an input value.
    • TYPE(), returns a number indicating the data type of a value.

Description

TYPE(InputValue)

  • TYPE() function can be used when the behavior of some function depends on the type of particular input value.
  • Argument can be a number, text, a logical value, array etc.
  • Below table shows the 'Return Type' with respect to the values:
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:

3200
8/19/2010
Welcome
TRUE
=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

References