The most difficult part of using the CONVERT function in Excel is knowing the abbreviations for the units. You can also convert from meters per hour to miles per hour: =CONVERT(65,"m/h","mph")įor one more example, we’ll convert our A2 value from bits to bytes with this formula: =CONVERT(A2,"bit","byte") How about a speed conversion? Here, you can convert the value in cell A2 from meters per hour to meters per second: =CONVERT(A2,"m/h","m/s") Need to perform some area conversions? This formula converts the value in cell A2 from square feet to square inches: =CONVERT(A2,"ft2","in2")Īnd with this formula, you can convert square meters to square miles: =CONVERT(A2,"m2","mi2")Īdditional area abbreviations you might need include: Here are a handful of additional volume abbreviations you might use: With this formula, you can convert a specific number U.S pints to U.K. You can convert teaspoons to tablespoons for the value in cell A2: =CONVERT(A2,"tsp","tbs") If you spend time in the kitchen, then you might find yourself converting those types of measurements. Tip: It’s likely that when using CONVERT with temperature and other units, it’s likely you’ll want to round decimal values. You can use this formula to convert 78 from Fahrenheit to Celsius: =CONVERT(78,"F","C") Note, you can also use “F” instead of “fah” and “C” instead of “cel.” Plus, you can use a number instead of a cell reference. Here, we’ll convert the temperature in cell A2 from Fahrenheit to Celsius: =CONVERT(A2,"fah","cel") Here are a few other abbreviations for common distance measurements:Ĭonverting temperatures is common when you’re working with someone who uses Celsius instead of Fahrenheit. You can also use a number as the reference and create the formula this way: =CONVERT(24,"in","ft") Distanceįor a simple distance conversion, we’ll convert the inches in cell A2 to feet using this formula: =CONVERT(A2,"in","ft") The reference argument can be a number or a cell reference.
The syntax for the function is CONVERT(reference, from_unit, to_unit) where you’ll need all three arguments. Which Units Can You Convert?Īs mentioned, you can convert more than 12 types of units with the function. So not only is it simple to use, but it’s also easy to remember. The nice thing about this function in Excel is that it uses a basic formula with only a few arguments. Whether you need feet to meters, Fahrenheit to Celsius, or teaspoons to tablespoons, you can take advantage of the CONVERT function in Microsoft Excel for a dozen types of conversion. The velocity in feet per second is equal to the distance in feet divided by time in seconds.Unit conversions are commonplace. įeet per second can be expressed using the formula: In formal expressions, the slash, or solidus (/), is used to separate units used to indicate division in an expression. For example, 1 foot per second can be written as 1 ft/s, 1 ft/sec, or 1 fps. Feet per second can be abbreviated as ft/s, and are also sometimes abbreviated as ft/sec or fps. The foot per second is a US customary and imperial unit of speed. The velocity in miles per hour is equal to the distance in miles divided by time in hours.įeet per second are a measurement of speed expressing the distance traveled in feet in one second. Miles per hour can be expressed using the formula: For example, 1 mile per hour can be written as 1 mph, 1 mi/h, or 1 MPH. Miles per hour can be abbreviated as mph, and are also sometimes abbreviated as mi/h or MPH. The mile per hour is a US customary and imperial unit of speed. Miles per hour are a measurement of speed expressing the distance traveled in miles in one hour.
0 kommentar(er)
