The right way to use the TYPE Perform in Microsoft Excel

The TYPE operate is an info operate in Microsoft Excel, and its function is to return a quantity indicating the info sort of a price. The person can not use the TYPE operate to find out if the cell incorporates a formulation as a result of the TYPE operate solely determines the kind of displayed worth.

Excel TYPE operate Components and Syntax

The Components for the TYPE operate is TYPE(worth).

The Syntax for the TYPE operate is under:

Worth: A Microsoft Excel worth, as an illustration, quantity, textual content, logical worth, and extra. It’s required. The TYPE operate returns numeric codes that symbolize the varieties of values, and there are 5 classes, specifically: Quantity = 1,  Textual content = 2, Logical worth = 4, Error worth = 16 and  Array = 64.

The right way to use the TYPE Perform in Excel

To make use of the TYPE operate, observe the strategies under.

  1. Launch Excel
  2. Create a desk or use an present desk
  3. Sort the formulation for the TYPE operate into the cell you wish to place the end result.
  4. Press Enter to see the end result

Launch Microsoft Excel.

Create a desk or use an present desk.

Sort the operate =TYPE(A2) into the cell you wish to place the end result.

Then press the enter key to see the end result.

A2 incorporates the worth that we wish to discover the info.

The end result for A2 returns the numeric code two, which suggests the sort is Textual content.

To see the opposite end result within the desk, pull the fill deal with down.

There are two different strategies to make use of the TYPE operate in Excel.

Methodology one is to click on the fx button on the highest left of the excel worksheet.

An Insert Perform dialog field will seem.

Contained in the dialog field within the part, Choose a Class, choose Info from the listing field.

Within the part Choose a Perform, select the TYPE operate from the listing.

Then click on OK.

A Perform Arguments dialog field will open.

Within the Worth part, enter into the entry field the cell  A2.

Then click on OK to see the end result.

Methodology two is to click on the Formulation tab and click on the Extra Features button within the Perform Library group.

Within the listing, hover the cursor over Info and choose the Sort Perform.

A Perform Arguments dialog field will seem.

We hope this tutorial helps you perceive how you can use the TYPE operate in Excel.

Leave a Reply

Your email address will not be published.

Don't Miss! random posts ..