Convert

[smason]

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

 

[Mike H]

Hi,

Neither of those arguments are accepted by convert

Try

=CONVERT(A1*100,"g","lbm")

or work in grammes in a1

Mike

 

[muddan madhu]

=CONVERT(A1,"kg","lbm")

 

[David Biddulph]

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.

 

[John C]

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.

 

[David Biddulph]

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"
" ?

 

[John C]

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.