Numeric formula returns strange result [closed]

asked 2014-07-30 19:04:57 +0200

DaveMN gravatar image

updated 2014-07-30 20:29:07 +0200

karolus gravatar image

The following formula, entered in a blank cell (Cell E48 on sheet 5 in a Calc spreadsheet) returns the result .08381706 - but the manually calculated value is 84.08
The formula is =102.3*((0.0299*13+0.0051*7.5*7.5)^0.5)
I'm running version 4.2.5.2, and have used the quotation marks to indicate verbatim transcription.
I had previously used essentially the same formula, but entered the numeric values by pointing to other cells where these values appeared, either as numeric entries or as formula results, with the same erroneous result. I've used the same operators in other places and in different combinations without problem. I've also stepped through the formula step by step using F9, and each individual operation (other than the final operation - multiplication by 102.3) shows an accurate result. Should I be looking for some hidden or concealed entries in the cell or affecting the cell? How? Is this a bug? Or does someone have another explanation?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-03-01 16:40:36.814782

Comments

1

Hallo
Your Formula returns 84.0838170622 which seems correct !

Karolus

karolus gravatar imagekarolus ( 2014-07-30 20:24:47 +0200 )edit

Same result as @karolus with 4.2.5.2. 84,0838170622

m.a.riosv gravatar imagem.a.riosv ( 2014-07-30 23:03:55 +0200 )edit

Also I can confirm the same result in 4.2.5.2 on XP. I also can recommend to use Tools > Detective to see which cells are linked to each other.

ROSt52 gravatar imageROSt52 ( 2014-07-31 02:20:21 +0200 )edit

Resultado correto 84,0838170622 ( WinXP + LibO 4.3.0.4 ).

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2014-08-01 01:30:59 +0200 )edit