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:
- value - Reference of a cell or a value for which you want to test the type.
- 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.
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.
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 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 ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.