February 23, 2012

CONVERT excel formula is not working

Problem: Excel refuse to accept formula for Convert

Formula found in a book or on web site is:
=CONVERT(A1*5280, "ft", "m")/1000

or
=CONVERT(1.0, "lbm", "kg")

It should contain semi-colon (;) instead of virgola (,) in order to work:

=CONVERT(A1*5280; "ft"; "m")/1000

Also, if NONAME appears, as help on Microsoft web page suggest - Analysis pack should be instaled, that is, it should be selected in Tools - Add-ins - Analysis Tool-pak

http://office.microsoft.com/en-us/excel-help/convert-HP005209022.aspx?CTT=5&origin=HP003056127

No comments: