Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Units of measure
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Units of measure
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 On Tue, 2 Oct 2007 15:26:01 -0700, Carl07 wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Units of measure
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) -- Gary''s Student - gsnu200748 "Carl07" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Units of measure
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. "Carl07" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Units of measure
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. "Carl07" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I paste in only absolute value of a measure (no units)? | Excel Discussion (Misc queries) | |||
Excel 2003 ~ How to change the default units of measure? | Setting up and Configuration of Excel | |||
Excel 2003 ~ How to change the default units of measure? | Excel Discussion (Misc queries) | |||
is there a way to only graph numbers above a certain measure | Excel Discussion (Misc queries) | |||
more ifs and an or thrown in for good measure | Excel Discussion (Misc queries) |