Imperial Weights in Excel

A

andrew.ford.af

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
 
L

Luke M

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locating values in a range and bringing up the corresponding price 3
Finding the corresponding value in a range? 4
Imperial weights 3
excel 2003 - revising a formula to make it more accurate 3
Excel formula help for calculating freight. 2
Machine-readable passport calculations 14
Excel fromula: Adding numbers from list to achieve a target 4
lbs ounces drams 3

Top