If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Imperial Weights in Excel
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 |
#2
|
|||
|
|||
Imperial Weights in Excel
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|