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
February 23, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment