1 stone = 14 pounds

i am trying to work out the average

of some english weight measurements

i have two fields stones pounds

example 10 - 13

10 - 13

10 - 13

easy right, the average is 10 - 13

but now try this

11 - 7

11 - 1

10 - 12

10 - 13

i am really struggling with this one

all the answers i get for similar problems to this are metric ie 10.92 i cant get the result

to go past .10 to .11 .12 .13

any ideas

I am not sure I understand your question completely. You can only average numbers. "10 - 13" is not a number. I think you want to translate your data into either pounds only or stones only (i.e. "decimal stones") first, then average the results, and finally convert the average back to stones & pounds.

For example:

11 stones and 7 pounds = 11*14 + 7 = 161 pounds;

11 stones and 1 pound = 11*14 + 1 = 155 pounds;

10 stones and 12 pound = 10*14 + 12 = 152 pounds;

10 stones and 13 pound = 10*14 + 13 = 153 pounds;

The average of { 161, 155, 152, 153 } is 155.25 pounds.

To extract the stones:

Div ( 155.25 ; 14 ) = 11 stones

To extract the remaining pounds:

Mod ( 155.25 ; 14 ) = 1.25 pounds

or, if you like:

Round ( Mod ( 155.25 ; 14 ) ; 0 ) = 1 pound

thank you that works fine