Excel - The TYPE function

February 2017



Description


As the name already suggest the TYPE function returns the type of a value.
The value returned is a follows (based on their types)
  • For Numbers, 1 is returned
  • For Text, 2 is returned
  • For Logical value (TRUE or FALSE), 4 is returned
  • For Array, 64 is returned
  • For Error value (#N/A), 16 is returned

Syntax


TYPE(value)

Related


Published by deri58. Latest update on November 19, 2011 at 09:43 AM by deri58.
This document, titled "Excel - The TYPE function," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).