Description: Hi In le calc the expression =EXP(-(LOG(A25)-LOG(0.08))^2/(2*0.69^2)) should evaluate to ~0.28. But it evaluates to ~3.5. It can be 'fixed' by adding a "1*": =EXP(-1*(LOG(A25)-LOG(0.08))^2/(2*0.69^2)) So the negative sign seems to be the problem. However it is not clear (to me at least), why this happens here and not elsewhere. E.g. exp(-5) and exp(-(5)) evaluate correctly. Steps to Reproduce: 1. Enter =EXP(-1*(LOG(A25)-LOG(0.08))^2/(2*0.69^2)) into a cell and hit Enter key. 2. 3. Actual Results: 3.53817919028921 Expected Results: 0.282631247943737 Reproducible: Always User Profile Reset: No Additional Info:
What's the value of A25 ? Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
-5^2 is evaluate in Calc (& Excel) as (-5)^2 and not -(5^2). The minus sign apply to the following number, not to the whole calculation. It is not a bug.
@ Xisco Faulí A25 is just 1. Sorry forgot to replace it. @GerardF Thanks, that seems to be it. Confusing, but apparently not a but...