Apr
12
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 OpenOffice.org 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
Comments
Leave a Reply
You must be logged in to post a comment.