Convert Function
I would just be guessing here.
=CONVERT(1,"btu","flb")
25036.98
In my old "Handbook of Chemistry & Physics"
the closest conversion listed is
Btu to "Foot-Poundals", and listed as 25020.1
Hmmm. Still a little off.
However, if I flip the page, and reverse the conversion, the factor given is
a little less precise...
0.0000399417
but
=1/0.0000399417
returns
25,036.49
Much closer. So, my guess is that Microsoft copied the wrong conversion,
and didn't use enough digits.
--
Dana DeLouis
"Duke Carey" wrote in message
...
And in 2007
"Vasant Nanavati" wrote:
I can confirm this error in Excel 2003 as well.
__________________________________________________ _______________________
"rmace" wrote in message
...
There is an error in EXCEL 2002 convert function for BTU to flb.
1 BTU should convert to 778 flb; however, it is calculating 25037.
Can someone else confirm this error?
Thank you.
--
Bob
|