Excel TYPE Function

What is TYPE function in Excel?

The TYPE function is one of the Information functions of Excel.

It Returns an integer representing the data type of a value.

For example number = 1; text = 2; logical value= 4; error value = 16; array = 64; compound data = 128.

We can find this function in Information of insert function Tab.

How to use TYPE function in excel

  1. Click on an empty cell (like F5).
empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select Information category.

5. Select TYPE function

6. Then select ok.

excel TYPE function

7. In the function arguments Tab you will see TYPE function.

8. Value section can be any value.

9. You will see the results in the formula result section.

How to use TYPE function in excel

Examples of TYPE function in Excel

Examples of TYPE function in Excel

TYPE related functions

  • Use ISNUMBER function to check whether a value is a number, and return TRUE or FALSE.
  • Use ISTEXT function to check whether a value is text, and returns TRUE or FALSE.
  • Use ISERROR function to check whether a value is an error, and return TRUE or FALSE.
  • Use ISFORMULA function to check whether a reference is to a cell containing a formula.

Leave a Reply

Your email address will not be published. Required fields are marked *