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!