View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default 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