Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |