From the course: Google Sheets: Advanced Formulas and Functions
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Convert values from one measure to another - Google Sheets Tutorial
From the course: Google Sheets: Advanced Formulas and Functions
Convert values from one measure to another
- [Instructor] When you live in the United States but do business with other countries, you spend a lot of time converting between imperial measures such as yards and pounds, to the metric system of meters and kilograms. In this movie I'll show you how to translate values from one system to another using the convert function. I have a series of values here and what I want to do is convert between two systems. So I have miles going to kilometers, then grams to ounces, and then I'll do two temperature changes Fahrenheit to Celsius and also to Kelvin. I'll start in cell B two, converting miles to kilometers I have 15 miles. So I'll type an equal sign in cell B two and then use the convert function followed my left parenthesis so I have my value, my start unit, and my end unit. The value is easy, that's in cell A two, so I'll click that, then a comma, now I need to know the start unit and the end unit. And if I look at the example it looks like converting grams to kilograms would use the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Round values up or down4m 49s
-
Create random numbers7m 24s
-
(Locked)
Multiply a set of numbers2m 38s
-
(Locked)
Find the sum and average of numbers1m 28s
-
(Locked)
Count types of values2m 59s
-
(Locked)
Count values conditionally7m 40s
-
(Locked)
Calculate permutations and combinations4m 7s
-
(Locked)
Find integer and remainder components of numbers and operations2m 59s
-
(Locked)
Convert values from one measure to another5m 13s
-
(Locked)
-
-
-
-
-
-