How do I add together lbs, ozs & drams in excel?

[treboryelbis]

Bearing in mind taht there is 16 drams in an ounce & 16 ounces in a lb.

[Norman Jones]

Hi Treboryelbis

See archive responses posted by Ron Rosenfeld:

http://tinyurl.com/55lec


---
Regards,
Norman



"treboryelbis" <[email protected]> wrote in message
news:[email protected]...
> Bearing in mind taht there is 16 drams in an ounce & 16 ounces in a lb.

[AlfD]

Hi!

Put this array in a sheet starting at A1

4....................15.....................................9...............................=256*A1+16*B1+C1
5.....................8....................................13...............................=256*A2+16*B2+C2
=INT(D3/256)....=INT((D3-256*A3)/16)....=D3-256*A3-16*B3.....=D1+D2

It converts the lbs and ozs to drams: adds them together and reconverts back to lbs ozs and drams.

So 4lb 15oz 9drams added to 5 lb 8 oz 13 drams equals the result in row 3.

If you hide the workings in col D, you have a typical "long addition" sum (at least, typical in my school days): inputs in a1..C1 and A2..C2: answer in A3..C3.

The same principles will work if you want to incorporate these formulae into your computations or, for that matter, VBA.

Alf