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

PPMT Function

The PPMT Function in Excel is used to calculate the principle of a given loan payment. If all you a

Read More »

INDEX Function

INDEX Function in Excel The Index Function in Excel returns the value of an array given a specific row and

Read More »

CUMPRINC Function

The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This

Read More »
Scroll to Top