Units of measure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can i use different units of measure within excel? I want to use
measurements of Mass ie Stones and Pounds. Is this possible? If so, can
anyone help me on how to use this? Any help is much appreciated. Thank you.
 
Not sure what your needs are.

Some measurements can be converted using the CONVERT function found in the
Anaalysis Toolpak.

I do not believe Stones is included so you would have to roll your own
conversion.

What units would you want to convert to stones and pounds?

This formula will give you stones and pounds from Kg

=INT(A3*0.071429)&" Stones "&ROUND((A3*0.071429-INT(A3*0.071429))*10,0)&" lbs"


This UDF will convert pounds to stones.

Function Stones(NumberArg As Double) As Double
If NumberArg < 0 Then
Exit Function
Else
Stones = 0.071429 * NumberArg
End If
End Function


Gord Dibben MS Excel MVP
 
There are no default unit of mass in Excel. You pick the units and you pick
the conversion factors. For example, say we have 500 in cell A1 and we mean
it to be pounds. Since a stone is about 14 pounds:

=INT(A1/14) gives the stones (35 stones)
and
=MOD(A1,14) gives the residual pounds (10 pounds)
 
You'll have to convert from whatever units of measurement you have to the
desired units of measurement. For example, 1 pound = 0.07142857 stone.
So to convert from pounds to stones, you use the formula =pounds *
0.07142857. To convert from stones to pounds you use the formula
=stones/0.07142857
If you have pounds in A1 and want the weight in stones in B1 then the
formula in B1 is =A1*0.07142857.
 
You'll have to convert from whatever units of measurement you have to the
desired units of measurement. For example, 1 pound = 0.07142857 stone.
So to convert from pounds to stones, you use the formula =pounds *
0.07142857. To convert from stones to pounds you use the formula
=stones/0.07142857
If you have pounds in A1 and want the weight in stones in B1 then the
formula in B1 is =A1*0.07142857.
 
Back
Top