Excel - The TYPE function

December 2016


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



Related :

This document entitled « Excel - The TYPE function » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.