Prev: Counting Characters In A String
Next: How does one put a watermark in an Excel worksheet?
From: andrew.ford.af on 29 Apr 2010 06:29
How do you use Imperial Weights in Excel, to allow formula for adding up
weights to use in pie charts etc. imperial weight measuring in stones. pounds
and fractions, eg 14st 8 1/4 lbs
From: Luke M on 29 Apr 2010 10:49
XL has not built in functions for summing up weights (of any base).
The best method I've seen involves putting the numerical part in one column,
and the label (st, lb, etc) in another column. Then you can write a type of
SUMPRODUCT formula where the label column triggers a conversion (similar to
how when adding hours and minutes, you must multiply the hours field by 60).

--
Best Regards,

Luke M
"andrew.ford.af" <andrew.ford.af(a)discussions.microsoft.com> wrote in message
news:17C03759-03B6-40F0-B0DC-454A5A061C59(a)microsoft.com...
> How do you use Imperial Weights in Excel, to allow formula for adding up
> weights to use in pie charts etc. imperial weight measuring in stones.
> pounds
> and fractions, eg 14st 8 1/4 lbs


 | 
Pages: 1
Prev: Counting Characters In A String
Next: How does one put a watermark in an Excel worksheet?