I'm trying to formulate some basic metric conversions in Excel. Just starting off, and I'm already stuck.
To convert kilograms to pounds, you multiply kilograms by 2.20, which equals 4.40, but actually it should be 4 pounds and 6.55 ounces. How can I create a formula that will give such results? There's 16 ounces in a pound, so I need to figure out how to equate anything to the right of the decimal to ounces.
Any suggestions?
Bookmarks