Adding/subtracting imperial stones and lbs

[halesowenmum]

Hiya

I'm using this to convert kgs to Stones and Lbs which works great:
=INT(ROUND(N1*2.2046,0)/14)&"st "&MOD(ROUND(N1*2.2046,0),14)&"lbs"

and gives this result:
9st 11lbs

For any cells with the stones and lbs results in them I'd like to be able to add/subtract and it add or subtract it correctly - if I use use plus or minus I get #VALUE!

Do I need to add and subtract with a formula?

Also, I'd like to be able to copy it along to other cells but if there's no value to show, for it to just return a completely blank cell? That would be really good.

Thanks.

 

[FormR]

For any cells with the stones and lbs results in them I'd like to be able to add/subtract and it add or subtract it correctly - if I use use plus or minus I get #VALUE!

Hi, why don;t you just do the addition/subtraction on the cells that contain the original values in kg and perform the same conversion on the result.

 

[halesowenmum]

Hi Form R - yes I could do that and probably that'll be the easiest - just wondered if there was a formula for doing it direct so to speak though.

I'm fiddling about with the kg's now. Thanks.

 

[FormR]

just wondered if there was a formula for doing it direct so to speak though.

Hi, it certainly wouldn't be an easy one, the formula you are using to calculate the st/lbs returns text which can't be used directly for mathematical calculations. You would have to jump through hoops convert it back to a number - which seems overkill as you already have the numeric equivalents.

 

[halesowenmum]

I got you.