Reply to Thread

Guest, we'd love to know what you think about the forum! Take the Diabetes Forum Survey 2025 »

Message: <blockquote data-quote="Buachaille" data-source="post: 10923" data-attributes="member: 1096">Assuming 100 Kilos is to be converted A1  =(100*2.2)/14This gives 15.71 Stones,  that is 15 Stones and .71 of a stoneCell A2.A2  =(14/100)*71 This gives 9.94 lbs, that is 9 lbs and .94 of 1 lbCell A3A3 =(16/100)*94This gives 15 oz + 0.4 of 1 oz.Take it you will stick there, or repeat the last cell to get grammes.You can compress the formula into a single cell with very little coding, or write the the formula so that succeeding cells pick up the residual from the preceding calculation ie A2 and A3 automatically get the residual values (in the example) of 71 and 94 - but perhaps its best to keep it simple. There are other ways of doing the maths.</blockquote>

Top Bottom