Excel - The TYPE function


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


Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
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).