Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Small logo
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Free Video Tutorials : Excel Formulas
Free Video Tutorials : Excel Formulas
Search

EXCEL FORMULAS: CONVERTING MEASUREMENTS

Learn how to convert different measurements in Excel

Background information and resources for Excel courses that we hope you find useful

You may find yourself in situations where you need to convert one measurement to another. This can be a pain, particularly if you are converting metric to imperial, or vice-versa. Even if you know the calculation steps involved, creating these in Excel can sometimes be tricky. Wouldn't it be great if Excel had a formula which just converted one measurement to another? Well guess what!

Whether we're talking about converting feet to metres, pints to litres, miles to kilometres or Fahrenheit to Celsius, there is a CONVERT function in Excel, which will perform all these calculations for you.

HOW TO CONVERT MEASUREMENTS

Let's use an example where we need to convert Fahrenheit to Celsius. Our first measurement is in cell A2. Click in to the cell where you want the answer to go and begin your formula with =CONVERT(A1,.

How to Convert Measurements

As soon as you have added the comma, a screen tip will appear with a whole host of different units of measurement. It's as simple as finding the one you need and double clicking to add this part of the formula.

Since we are converting Farenheit to Celsius so we need to select Degree Fahrenheit first.

Excel Formulas: Converting measurements

Once this is selected, add another comma and select your second unit of measurement (Degree Celsius, in this example). Excel cleverly reduces the options the second time around, so you are not converting Fahrenheit to centimetres, for example!

Remember to close the bracket/parenthesis to complete the formula and there you have it.

Excel Formulas: Converting measurements

CONVERSION UNITS

The units you can convert from break down into the following categories:

  • Weight & mass
  • Distance
  • Time
  • Pressure
  • Energy
  • Power
  • Temperature
  • Liquid measure

USEFUL CONVERSION FORMULAS

You can also use the actual number rather than a cell reference; for example:

=CONVERT(1.0, "lbm", "kg") will convert 1 pound mass to kilograms (0.453592)

=CONVERT(68, "F", "C") will convert 68 degrees Fahrenheit to Celsius (20)

=CONVERT(CONVERT(100,"ft","m"),"ft","m") will convert 100 square feet into square meters (9.290304)

=CONVERT(2.5, "ft", "sec") - in this case, data types are not the same so an error is returned (#N/A)

The results of these calculations often create numbers with lots of decimal places. From here, you can use the ROUND function to round these numbers up or down.

WE HOPE YOU FOUND THIS USEFUL

Want to see how we can really help you?

LINKS TO MORE ...

Main Excel Resources Page

Excel Resources

Video tutorials & articles, and templates to help you work better in Excel

      Click to view

 

Video Tutorials - Excel Formulas

Video Tutorials - Excel Formulas

Learn and work with new Excel formulas to help create effective, automated spreadsheets

Click to view

Excel Formulas: Circular reference warning

Excel Formulas: Circular reference warning

See what a Circular Reference warning means and how to locate it in your Excel spreadsheet

      Click to read more

 

Excel Formulas: Calculate difference in dates

Excel Formulas: Calculate difference in dates

Learn how to calculate the difference between two dates in your Excel spreadsheet in a few easy steps

      Click to read more

Excel Formulas: Why a formula doesn't work

Excel Formulas: Why a formula doesn't work

Find out why your formula might not work in Microsoft Excel and how to fix it

      Click to read more

 

Excel Formulas: How to work out gross profit

Excel Formulas: How to work out gross profit

Find out how to use a formula to work out gross profit in Microsoft Excel

      Click to read more

GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

HOW TO CONVERT MEASUREMENTS IN EXCEL

We can enhance your skills with courses for Microsoft Excel spreadsheets at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our excel courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering Microsoft Excel course all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of courses for Excel to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Free Video Tutorials : Excel Formulas.

Why not contact us today to see how we can help with providing your MS Excel classes ?


Stay in touch

Stay In Touch!

Google+
LinkedIn
Twitter
FaceBook
YouTube

Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:   0333 6000 777



Back to top