View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default convert kilograms to stones AND pounds

Would it not be better to ROUND() or TRUNC() the pounds because you formula
returns


Yes, it would be better. Thanks for the save.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Mon, 27 Oct 2008 23:59:30 -0000, "Sandy Mann"
wrote:

Chip,

Would it not be better to ROUND() or TRUNC() the pounds because you formula
returns

10 Stones 5.20000000000002 Pounds

for 66 Kg