Excel - The TYPE function

April 2018


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


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 (https://ccm.net/).
Excel - C:\Windows\system32\SGXLADDIN.dll could not be found
Excel - The NA( ) function