Convert pounds to kilograms in Excel and Google Sheets
=CONVERT(A2,"lbm","kg")
A2 = data cell
Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.Convert pounds to kilograms in Excel
How to convert pounds to kilograms in Excel?
CONVERT POUNDS TO KILOGRAMS — EXCEL FORMULA AND EXAMPLE
=CONVERT(A2,"lbm","kg")
A2 = data cell
To convert Kilograms to Pounds switch the unit position (kg & lbm) 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
Convert pounds to kilograms in Google Sheets
How to convert pounds to kilograms in Google Sheets?
CONVERT POUNDS TO KILOGRAMS — GOOGLE SHEETS FORMULA AND EXAMPLE
=CONVERT(A2,"lbm","kg")
A2 = data cell
To convert Kilograms to Pounds switch the unit position (kg & lbm) 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
- Convert kilograms to pounds
- Convert kilograms to stones
- Convert stones to kilograms
- Convert acres to hectares
- Convert hectares to acres
- Sum by month
- SUMIF cells if contains part of a text string
- Sum total sales based on quantity & price
- Combine date and time
- Convert 1-12 to month name
- Dynamic current date and time
- Count blank cell
- Count cell between two values
- Combine two or more cell
- Extract left before first space
- Extract the nth words in a text string
- Flip the first and last name
- SUMIF formulas and example
- SUMIFS formulas and example
- COUNTIF formulas and example
- IF formulas and example
- TEXT formulas and example
- CONVERT formulas and example
- Change the negative number to zero
- Change negative to positive numbers
- Calculate percentage changes for containing zero or negative values
- Convert date to text
- Convert time to text
- Convert weekday string to number
- Combine two or more cells with a line break
- Combine two or more cells and transpose
- Count cells over 10 characters
- Count cells that are not blank
- Count if cells contain a specific text
- Count cells that begin with a specific text
- COUNTIF based on multiple criteria