• Learn
  • Blog
  • Pricing
  • About
  • Sign in

Tip: Convert values with CONVERT

Converting values from one measurement system to another using plain formulas is tedious and error-prone. Use the CONVERT formula function instead to perform these conversions. It supports more than one hundred different units.

Converting values from one measurement system to another is an integral part of many calculator apps. For instance, your app may convert a volume from fluid ounces to milliliters, a weight (mass) from pounds to kilograms or a length from meters to inches.

Doing these conversions isn’t hard, mathematically speaking. Here’s the formula for converting a volume from fluid ounces to milliliters:

VolumeInFluidOunces * 29.5735295625

This is the formula for converting a weight in pounds to kilograms:

WeightInPounds * 0.45359237

Finally, this is the formula for converting meters to inches:

LengthInMeters * 39.3700787

While simple, looking up these formulas can get tedious fast — and it’s easy to get something wrong.

There’s a better way. When we added hundreds of formula functions to Calcapp back in 2016, we also added support for the CONVERT function, popularized by Microsoft Excel. Using CONVERT, you can easily convert a value from one measurement system to another.

Here’s a formula for converting fluid ounces to milliliters, this time using CONVERT:

CONVERT(VolumeInFluidOunces, "oz", "ml")

This formula converts a weight in pounds to kilograms using CONVERT:

CONVERT(WeightInPounds, "lbm", "kg")

Finally, this formula converts meters to inches using CONVERT:

CONVERT(LengthInMeters, "m", "in")

The CONVERT function supports more than a hundred different units. Use the reference sidebar to learn about them all. Also, note that there may be slight variations between what units Calcapp supports and what units popular spreadsheets support.

Do you want to share a tip with other Calcapp users through this blog? Would you like us to add additional units to CONVERT? Let us know!

« Feature: Usage statistics on individual users Sample app: Body mass index (BMI) calculator »