Excel TYPE Function

HomeExcel FunctionsExcel TYPE Function (Example + Sample File)

​What is EXCEL TYPE FUNCTION

How to use it

To learn how to use the TYPE function in Excel, you need to understand its syntax and arguments:

Syntax

TYPE(value)

Arguments

  • value - Reference of a cell or a value for which you want to test the type.

Notes

  • When you a test value from a cell that has a formula, then it will test the value which is return by that formula.
  • If you refer to a blank cell, it will return number 1 as a result.
  • If you refer to a cell that contains a date, it will return 1 in a result as a date has a value in number.

Example

To master TYPE function we need to try it out in an example, so make sure to check out the below one:

In the below formula, we have used TYPE with IF. 

=IF(TYPE(F3)<>1,”Enter Valid Quantity”,E3*F3)

In this formula, TYPE returns a number that represents the type of the value and then there’s a condition in the IF.

If that number does not equals to the 1 which means is the supplied value is not a number and IF returns the message "Enter a Valid Value".

And if it is there, it multiples the quantity with the price.


Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.