Recently I had to create a table to convert from lb to kg.

The way I did it was to start spreadsheet program – Excell or and fill up the conversion formula and desired data range.

1. In a cell fill the conversion in my case 1 lb = 0.453592 kg I used cell B1

2. Fill up a column with desired data

3. in next column type the formula =A3*$B$1

4. Copy the formula to other rows

5. Done

This method could be used for other conversions just by changeng the value in B1


Leave a Reply