| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert
Hello can some one see whats wrong with this formular
=CONVERT(A1,"kg","lb") where a1 = 10 i want to convert a1 from kg to lb but i am getting the N/A# in the results i have the addisn installed ana tools pack and solver any ideas |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert
Hi,
Neither of those arguments are accepted by convert Try =CONVERT(A1*100,"g","lbm") or work in grammes in a1 Mike "smason" wrote: Hello can some one see whats wrong with this formular =CONVERT(A1,"kg","lb") where a1 = 10 i want to convert a1 from kg to lb but i am getting the N/A# in the results i have the addisn installed ana tools pack and solver any ideas |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert
=CONVERT(A1,"kg","lbm")
On Oct 23, 3:37*pm, smason wrote: Hello can some one see whats wrong with this formular =CONVERT(A1,"kg","lb") where a1 = 10 i want to convert a1 from kg to lb but i am getting the N/A# in the results i have the addisn installed ana tools pack and solver any ideas * |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert
Perhaps it's time for another reminder that all Excel functions (except one)
are covered by Excel help, so answers to questions like this can be found there. -- David Biddulph "Mike H" wrote in message ... Hi, Neither of those arguments are accepted by convert Try =CONVERT(A1*100,"g","lbm") or work in grammes in a1 Mike "smason" wrote: Hello can some one see whats wrong with this formular =CONVERT(A1,"kg","lb") where a1 = 10 i want to convert a1 from kg to lb but i am getting the N/A# in the results i have the addisn installed ana tools pack and solver any ideas |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert
Well, that's not entirely accurate. kg IS recognized by xl2003, even though
not listed in help. Also, I think you meant to multiply by 1000, not 100, in your formula. :D -- ** John C ** "Mike H" wrote: Hi, Neither of those arguments are accepted by convert Try =CONVERT(A1*100,"g","lbm") or work in grammes in a1 Mike "smason" wrote: Hello can some one see whats wrong with this formular =CONVERT(A1,"kg","lb") where a1 = 10 i want to convert a1 from kg to lb but i am getting the N/A# in the results i have the addisn installed ana tools pack and solver any ideas |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert
Does your help for the CONVERT function not include the part that says:
"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" " ? -- David Biddulph "John C" <johnc@stateofdenial wrote in message ... Well, that's not entirely accurate. kg IS recognized by xl2003, even though not listed in help. Also, I think you meant to multiply by 1000, not 100, in your formula. :D -- ** John C ** "Mike H" wrote: Hi, Neither of those arguments are accepted by convert Try =CONVERT(A1*100,"g","lbm") or work in grammes in a1 Mike "smason" wrote: Hello can some one see whats wrong with this formular =CONVERT(A1,"kg","lb") where a1 = 10 i want to convert a1 from kg to lb but i am getting the N/A# in the results i have the addisn installed ana tools pack and solver any ideas |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert
kg still isn't listed together. I was calling into account Mike saying that
kg isn't recognized, and then erred again when multiplying by 100 instead of 1000. You are just upset at me because of the other post regarding budget redemption. -- ** John C ** "David Biddulph" wrote: Does your help for the CONVERT function not include the part that says: "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" " ? -- David Biddulph "John C" <johnc@stateofdenial wrote in message ... Well, that's not entirely accurate. kg IS recognized by xl2003, even though not listed in help. Also, I think you meant to multiply by 1000, not 100, in your formula. :D -- ** John C ** "Mike H" wrote: Hi, Neither of those arguments are accepted by convert Try =CONVERT(A1*100,"g","lbm") or work in grammes in a1 Mike "smason" wrote: Hello can some one see whats wrong with this formular =CONVERT(A1,"kg","lb") where a1 = 10 i want to convert a1 from kg to lb but i am getting the N/A# in the results i have the addisn installed ana tools pack and solver any ideas |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can the "convert" function in excel convert to UK gallons? | Excel Discussion (Misc queries) | |||
| how will i convert 05.01.2007 convert 05.Jan.2007 format? | New Users to Excel | |||
| convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
Linear Mode
