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

=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


No comments: