Good advice Thanks
--
Gary''s Student - gsnu200854


"Rick Rothstein" wrote:

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)

--
Rick (MVP - Excel)


"Gary''s Student" wrote in message
...
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
--
Gary''s Student - gsnu200854


"Pagie" wrote:

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