Convert kilograms to pounds in Excel and Google Sheets

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

A2 = data cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Convert kilograms to pounds in Excel

How to convert kilograms to pounds in Excel?

CONVERT KILOGRAMS TO POUNDS — EXCEL FORMULA AND EXAMPLE

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

  • A2 = data cell

  • To convert Pounds to Kilograms switch the unit position (lbm & kg) in the above formula

Weight and mass units

  • Gram = "g"

  • Slug = "sg"

  • Pound mass (avoirdupois) = "lbm"

  • U (atomic mass unit) = "u"

  • Ounce mass (avoirdupois) = "ozm"

  • Grain = "grain"

  • U.S. (short) hundredweight = "cwt" or "shweight"

  • Imperial hundredweight = "uk_cwt" or "lcwt" ("hweight")

  • Stone = "stone"

  • Ton = "ton"

  • Imperial ton = "uk_ton" or "LTON" ("brton")

💡 Detailed measurement units definition outlined here

Convert kilograms to pounds in Google Sheets

How to convert kilograms to pounds in Google Sheets?

CONVERT KILOGRAMS TO POUNDS — GOOGLE SHEETS FORMULA AND EXAMPLE

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

  • A2 = data cell

  • To convert Pounds to Kilograms switch the unit position (lbm & kg) in the above formula

Available unit conversions by category

  • Weight – u, grain, g, ozm, lbm, stone, sg, cwt, uk_cwt, ton, uk_ton

  • Distance – ang, Picapt, pica, in, ft, yd, m, ell, mi, survey_mi Nmi, ly, parsec

  • Time – sec, min, hr, day, yr

  • Pressure – Pa, mmHg, Torr, psi, atm

  • Force – dyn, pond, N, lbf

  • Energy – eV, e, J, flb, c, cal, BTU, Wh, HPh

  • Power – W, PS, HP

  • Magnetism – ga, T

  • Temperature – C, F, K, Rank, Reau

  • Volume – ang^3, Picapt^3, tsp, tspm, tbs, in^3, oz, cup, pt, uk_pt, qt, l, uk_qt, gal, uk_gal, ft^3, bushel, barrel, yd^3, m^3, MTON, GRT, mi^3, Nmi^3, ly^3

  • Area – ang^2, Picapt^2, in^2, ft^2, yd^2, m^2,ar, Morgen,uk_acre, us_acre, ha, mi^2, Nmi^2, ly^2

  • Information – bit, byte

  • Speed – m/hr, mph, kn, admkn, m/s

💡 Detailed measurement units definition outlined here