Does anyone have a template to convert Kilos to Pounds & Ounces

P

Pagie

I am looking for a template that converts kilos to Pounds and Ounces to the
nearest ounce. If anyone can help I'd be most grateful
Regards
Ray Page
 
G

Gary''s Student

With kilos in A1, In B1 & C1:

=ROUND(convert(A1,"kg","lbm"),0)
=ROUND(16*(convert(A1,"kg","lbm")-B1),0)

so 17 kilos will show as 37 lbs 8 ozs
 
R

Rick Rothstein

You shouldn't use ROUND for the conversion to pounds as that can round a
value (with a fraction greater than 0.5) up when you don't want it to (try
19 kilograms to see the problem). Here are the formulas I would use (I like
my second one instead of yours as it only relies on the cell with the
kilogram value in it meaning it can be placed anywhere without having to
attend to the B1 reference to the pounds value...

=INT(CONVERT(A1,"kg","lbm"))
=ROUND(16*MOD(CONVERT(A1,"kg","lbm"),1),0)
 
Top