https://bz.apache.org/ooo/show_bug.cgi?id=127788
Issue ID: 127788
Issue Type: DEFECT
Summary: average function gives incorrect result
Product: Calc
Version: 4.1.3
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Critical
Priority: P5 (lowest)
Component: ui
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
When using the AVERAGE function to find the average of a row of numbers it
gives an incorrect result. For example when averaging the numbers -875.63,
-402.21, -2300.03, -943.86, +1832.96, the correct result is: -537.7544,
but the AVERAGE function says it is +478.66. Both the sign and the number are
wrong! This is just 1 example from many rows I have on the sheet. When using
the SUM function, I get the correct result. (SUM(-875.63,
-402.21,-2300.03,-943.86,+1832.96)/5)
--
You are receiving this mail because:
You are the assignee for the issue.
