Examples
The TYPE function returns a numeric code: If TYPE is given an array constant, or a range, the result is 64: TYPE returns 16 for errors:
Notes
You can’t use TYPE to test for a formula, because TYPE evaluates the result. Excel dates and times are numbers, and therefore return 1.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
