Convert pounds to grams in Excel and Google Sheets

1 POUND = 453.59237 GRAMS

100 GRAM = 0.2204 POUNDS

To convert pounds into grams you can use COVERT functions in Excel and Google Sheets

To convert pounds to grams

=CONVERT(A2,"lbm","g")

1 Pounds = 453.59237 Grams

To convert grams to pounds, just switch the unit place.

=CONVERT(A2,"g","lbm")

100 Grams = 0.2204 Pounds

To convert pounds to ounces

=CONVERT(A2,"lbm","ozm")

1 Pounds = 16 Ounces

To convert pounds to kilograms (kgs)

=CONVERT(A2,"lbm","kg")

1 Pounds = 0.045359 kg

To convert kilograms (kgs) to pounds, just switch the unit place.

=CONVERT(A2,"kg","lbm")

1 kg = 2.204 Pounds

💡 Above formulas will work in both Excel and Google Sheets, and the units must be inside a quotation mark (" "), and you will get the "#NAME?" error if you have missed a quotation mark for your units

💡 Detailed measurement units definition outlined here

Convert pounds to grams in Excel and Google Sheets

How to convert pounds to grams in Excel and Google Sheets?

CONVERT POUNDS TO GRAMS — EXCEL AND GOOGLE SHEETS FORMULA AND EXAMPLE

To convert pounds to grams

=CONVERT(A2,"lbm","g")

  • 1 POUND = 453.59237 GRAMS

  • 100 GRAM = 0.2204 POUNDS