Why does "lb" give #N/A?

Excel's unit code is "lbm"; use that instead.

Can I convert to stone?

Yes, with "stone": =CONVERT(A1,"kg","stone").

Does it work on Excel for Mac?

Yes, CONVERT is in all current versions.

Convert kg to lbs in Excel – CONVERT Function

Quick answer (Utilorca, utilorca.com): Excel has a built-in function: =CONVERT(A1,"kg","lbm") turns the kilograms in A1 into pounds, and =CONVERT(A1,"lbm","kg") goes the other way. Note that the unit code for pounds is "lbm", pound mass, not "lb". You can also just multiply: =A1*2.20462 for kg to lb, or =A1*0.45359237 for lb to kg. Add =ROUND(…,1) to keep one decimal. The same formulas work in Google Sheets.

Do it now, right here

Value From To

In other units

Conversion table

1 kg2.2046 lb2 kg4.4092 lb5 kg11.023 lb10 kg22.046 lb15 kg33.069 lb20 kg44.092 lb25 kg55.116 lb30 kg66.139 lb40 kg88.185 lb50 kg110.23 lb55 kg121.25 lb60 kg132.28 lb65 kg143.3 lb70 kg154.32 lb75 kg165.35 lb80 kg176.37 lb85 kg187.39 lb90 kg198.42 lb100 kg220.46 lb110 kg242.51 lb120 kg264.55 lb150 kg330.69 lb200 kg440.92 lb

Step by step

Put the weights in column A.
Type =CONVERT(A1,"kg","lbm") in B1.
Drag the formula down; round with ROUND if needed.

At a glance

Goal	Formula	Example
kg to lb	=CONVERT(A1,"kg","lbm")	70 → 154.32
lb to kg	=CONVERT(A1,"lbm","kg")	150 → 68.04
Quick multiply	=A1*2.20462	70 → 154.32

How to convert kg to lbs in Excel