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?

Hallo

Your Formula returns `84.0838170622`

which seems correct !

Karolus

Same result as @Karolus with 4.2.5.2. `84,0838170622`

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.

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