View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default convert kilograms to stones AND pounds

Thanks Sandy

Typo on the 10

Not sure what you mean by the second part.


Gord


On Mon, 27 Oct 2008 23:55:12 -0000, "Sandy Mann"
wrote:

Gord,

=INT(A3*0.071429)&" Stones "&ROUND((A3*0.071429-INT(A3*0.071429))*10,0)&"
lbs"


Should you not have multiplied by 14 instead of 10? (Unless of course
Canada has metric stones <g)

and would it not be better to divide by 14 then multiply by 0.071429?