If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
a simple math formula
Hi Dave,
First, I may have missed it, but I don't think anyone has pointed out that CONVERT is an Analysis ToolPak function in 2003 or earlier so you need to attach that Add-in - choose Tools, Add-ins, and check Analysis ToolPak. Second the conversion factors can be found in 2007 or 2003, by starting to type the function =CONVERT( and then clicking the fx button on the Formula Bar and clicking the Help on this function hyperlink. Here is the complete list in 2007 (note there are some additions in 2007 that will not work in 2003). Also, unlike most places in Excel, the units ARE case sensitive. Weight and mass From_unit or to_unit Gram "g" Slug "sg" Pound mass (avoirdupois) "lbm" U (atomic mass unit) "u" Ounce mass (avoirdupois) "ozm" Distance From_unit or to_unit Meter "m" Statute mile "mi" Nautical mile "Nmi" Inch "in" Foot "ft" Yard "yd" Angstrom "ang" Pica (1/72 in.) "Pica" Time From_unit or to_unit Year "yr" Day "day" Hour "hr" Minute "mn" Second "sec" Pressure From_unit or to_unit Pascal "Pa" (or "p") Atmosphere "atm" (or "at") mm of Mercury "mmHg" Force From_unit or to_unit Newton "N" Dyne "dyn" (or "dy") Pound force "lbf" Energy From_unit or to_unit Joule "J" Erg "e" Thermodynamic calorie "c" IT calorie "cal" Electron volt "eV" (or "ev") Horsepower-hour "HPh" (or "hh") Watt-hour "Wh" (or "wh") Foot-pound "flb" BTU "BTU" (or "btu") Power From_unit or to_unit Horsepower "HP" (or "h") Watt "W" (or "w") Magnetism From_unit or to_unit Tesla "T" Gauss "ga" Temperature From_unit or to_unit Degree Celsius "C" (or "cel") Degree Fahrenheit "F" (or "fah") Kelvin "K" (or "kel") Liquid measure From_unit or to_unit Teaspoon "tsp" Tablespoon "tbs" Fluid ounce "oz" Cup "cup" U.S. pint "pt" (or "us_pt") U.K. pint "uk_pt" Quart "qt" Gallon "gal" Liter "l" (or "lt") The following abbreviated unit prefixes can be prepended to any metric from_unit or to_unit. Prefix Multiplier Abbreviation exa 1E+18 "E" peta 1E+15 "P" tera 1E+12 "T" giga 1E+09 "G" mega 1E+06 "M" kilo 1E+03 "k" hecto 1E+02 "h" dekao 1E+01 "e" deci 1E-01 "d" centi 1E-02 "c" milli 1E-03 "m" micro 1E-06 "u" nano 1E-09 "n" pico 1E-12 "p" femto 1E-15 "f" atto 1E-18 "a" If this helps, please click the Yes button Cheers, Shane Devenshire "Dave Horne" wrote: Martin, one more question. After I was given the unit lbm (for pound), where would I have found that infomation? I really prefer looking up this stuff myself but couldn't find anything. I see there are many formulas as my disposal but without knowing the correct syntax or knowing what the abbreviations are, it makes this quite a challenge. kg for kilogram is obvious (though I didn't know I could actully use that in a formula), lbm instead of lb (for pound) - I never would have stumbled onto that. Can a list of these measurement units be found in Excel 2007? Also, if you could recommend a guide, a book (or a link) to learn the syntax, I'd appreciate it. Thanks again, Dave Horne "MartinW" wrote in message ... Hi Dave, You've led yourself astray here on a few counts. 1) No need to use =SUM(B5)*2.2, just =B5*2.2 will do fine 2) 2.2 is not the correct conversion factor, it should be 2.20462262 3) If you simply used Roger's original formula you wouldn't need to bother with the correct conversion factor. HTH Martin "Dave Horne" wrote in message ... I came up with =SUM(B5)*2.2 which works for converting B5 to C5. I almost posted too soon with the following, but I saw by dragging the black box in the right corner (of C5), the simple math equation is now applied to every B cell. It's been a while but I at least solved this simple task. Thanks, Dave Horne "Roger Govier" roger@technology4unospamdotcodotuk wrote in message ... Hi David In C5 enter =CONVERT(B5,"kg","lbm") and copy down through C6:C77 -- Regards Roger Govier "Dave Horne" wrote in message ... Hi, I'm new to this and have a very simple question. I have values, simple numbers representing weight in kg, that I wish to automatically convert to US pounds. The 'kg' numbers are in fields B5 - to B77 for example. I want the conversion result (simply multiplying each B cell entry by 2.2) placed in the ''cell adjacent. Thanks! Dave Horne |
#12
|
|||
|
|||
a simple math formula
///If this helps, please click the Yes button///
I'm viewing this from a news reader and have clicked 'yes' in my mind. I really appreciate everyone's help. I've already started a free online tutorial from MS. Thanks everyone! Dave Horne "Shane Devenshire" wrote in message ... Hi Dave, First, I may have missed it, but I don't think anyone has pointed out that CONVERT is an Analysis ToolPak function in 2003 or earlier so you need to attach that Add-in - choose Tools, Add-ins, and check Analysis ToolPak. Second the conversion factors can be found in 2007 or 2003, by starting to type the function =CONVERT( and then clicking the fx button on the Formula Bar and clicking the Help on this function hyperlink. Here is the complete list in 2007 (note there are some additions in 2007 that will not work in 2003). Also, unlike most places in Excel, the units ARE case sensitive. Weight and mass From_unit or to_unit Gram "g" Slug "sg" Pound mass (avoirdupois) "lbm" U (atomic mass unit) "u" Ounce mass (avoirdupois) "ozm" Distance From_unit or to_unit Meter "m" Statute mile "mi" Nautical mile "Nmi" Inch "in" Foot "ft" Yard "yd" Angstrom "ang" Pica (1/72 in.) "Pica" Time From_unit or to_unit Year "yr" Day "day" Hour "hr" Minute "mn" Second "sec" Pressure From_unit or to_unit Pascal "Pa" (or "p") Atmosphere "atm" (or "at") mm of Mercury "mmHg" Force From_unit or to_unit Newton "N" Dyne "dyn" (or "dy") Pound force "lbf" Energy From_unit or to_unit Joule "J" Erg "e" Thermodynamic calorie "c" IT calorie "cal" Electron volt "eV" (or "ev") Horsepower-hour "HPh" (or "hh") Watt-hour "Wh" (or "wh") Foot-pound "flb" BTU "BTU" (or "btu") Power From_unit or to_unit Horsepower "HP" (or "h") Watt "W" (or "w") Magnetism From_unit or to_unit Tesla "T" Gauss "ga" Temperature From_unit or to_unit Degree Celsius "C" (or "cel") Degree Fahrenheit "F" (or "fah") Kelvin "K" (or "kel") Liquid measure From_unit or to_unit Teaspoon "tsp" Tablespoon "tbs" Fluid ounce "oz" Cup "cup" U.S. pint "pt" (or "us_pt") U.K. pint "uk_pt" Quart "qt" Gallon "gal" Liter "l" (or "lt") The following abbreviated unit prefixes can be prepended to any metric from_unit or to_unit. Prefix Multiplier Abbreviation exa 1E+18 "E" peta 1E+15 "P" tera 1E+12 "T" giga 1E+09 "G" mega 1E+06 "M" kilo 1E+03 "k" hecto 1E+02 "h" dekao 1E+01 "e" deci 1E-01 "d" centi 1E-02 "c" milli 1E-03 "m" micro 1E-06 "u" nano 1E-09 "n" pico 1E-12 "p" femto 1E-15 "f" atto 1E-18 "a" If this helps, please click the Yes button Cheers, Shane Devenshire "Dave Horne" wrote: Martin, one more question. After I was given the unit lbm (for pound), where would I have found that infomation? I really prefer looking up this stuff myself but couldn't find anything. I see there are many formulas as my disposal but without knowing the correct syntax or knowing what the abbreviations are, it makes this quite a challenge. kg for kilogram is obvious (though I didn't know I could actully use that in a formula), lbm instead of lb (for pound) - I never would have stumbled onto that. Can a list of these measurement units be found in Excel 2007? Also, if you could recommend a guide, a book (or a link) to learn the syntax, I'd appreciate it. Thanks again, Dave Horne "MartinW" wrote in message ... Hi Dave, You've led yourself astray here on a few counts. 1) No need to use =SUM(B5)*2.2, just =B5*2.2 will do fine 2) 2.2 is not the correct conversion factor, it should be 2.20462262 3) If you simply used Roger's original formula you wouldn't need to bother with the correct conversion factor. HTH Martin "Dave Horne" wrote in message ... I came up with =SUM(B5)*2.2 which works for converting B5 to C5. I almost posted too soon with the following, but I saw by dragging the black box in the right corner (of C5), the simple math equation is now applied to every B cell. It's been a while but I at least solved this simple task. Thanks, Dave Horne "Roger Govier" roger@technology4unospamdotcodotuk wrote in message ... Hi David In C5 enter =CONVERT(B5,"kg","lbm") and copy down through C6:C77 -- Regards Roger Govier "Dave Horne" wrote in message ... Hi, I'm new to this and have a very simple question. I have values, simple numbers representing weight in kg, that I wish to automatically convert to US pounds. The 'kg' numbers are in fields B5 - to B77 for example. I want the conversion result (simply multiplying each B cell entry by 2.2) placed in the ''cell adjacent. Thanks! Dave Horne |
|
Thread Tools | |
Display Modes | |
|
|