Results will update automatically when values in column B change. To convert pounds to kilograms, the formula used is in C5, copied down, is: Note: CONVERT is case-sensitive, so the text values used for units must match exactly.
Kilograms to pounds
To convert from kilograms to pounds, the formula would be:
Pounds to Stones
To convert pounds to kilograms, the formula used in D5, copied down, is
Table set-up
The table in the example shown uses formulas to make it easy to change the staring point and range of the values in column B. The formula in B5 simply points to G4: The formula in G5, copied down, is: When values in G4 or G5 are changed, the values in column B update dynamically.
Other conversions
You can use CONVERT to convert weight, distance, time, pressure, force, energy, power, magnetism, temperature, liquid, and volume. Unit strings must be valid and in the proper case. This page shows available options in each category.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
