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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top