Manuals/calci/TYPE

From ZCubes Wiki
Revision as of 15:54, 9 August 2018 by Devika (talk | contribs)
Jump to navigation Jump to search
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