CONVERT Function in Excel

The CONVERT function in Excel converts a number from a specific measurement system to another. Some common uses of this function is converting various lengths. For example, you can easily determine how many inches are in a certain amount of feet. You can also convert metric to imperial for all the Americans.

Syntax:

=CONVERT (number, from_unit, to_unit)

Arguments:

  • number – The numeric value to convert.
  • from_unit – The starting units for number.
  • to_unit – The ending units for the result.

CONVERT Function Usage Examples

In order to use the CONVERT Function, you need to specify the specific units. Look at the examples below. You can easily select which units you want to convert based on the chart below.

=CONVERT(50,"in","ft") /// returns 4.166
=CONVERT(50,"gal","oz") /// returns 6400
=CONVERT(50,"gal","cup") /// returns 800
=CONVERT(50,"bushel","yd^3") /// returns 2.3045

The following conversion option choices are available in Excel by default.

CONVERT Function Units
Complete list of Convert Functions in Excel

Leave a Reply

ISERROR Function

The ISERROR function in Excel returns TRUE for any error type excel generates. This list of errors includes: #N/A, #VALUE!,

Read More »

AverageIFS Function

Finding the arithmetic mean in Excel is very easy.  In this example, we will be using the AVERAGEIFS function. We

Read More »

Autofilter in Excel

AutoFilter Excel offers an easy way to search or modify complex data sets using the AutoFilter feature. In order to

Read More »
Scroll to Top