https://bugs.documentfoundation.org/show_bug.cgi?id=153707
Bug ID: 153707
Summary: NPV function error with big number
Product: LibreOffice
Version: 7.4.5.1 release
Hardware: x86-64 (AMD64)
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Given a list of these numbers:
862500
862500
862500
862500
862500
862500
862500
=NPV(0.1, 862500,862500,862500,862500,862500,862500,862500...)
The cell value becomes "###"
However, we I do the same with the small values 862.5, it works.
=NPV(0.1, 862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5)
return 5.299,69
Steps to Reproduce:
Given a list of these numbers:
862500
862500
862500
862500
862500
862500
862500
=NPV(0.1, 862500,862500,862500,862500,862500,862500,862500...)
The cell value becomes "###"
However, we I do the same with the small values 862.5, it works.
=NPV(0.1, 862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5)
return 5.299,69
Actual Results:
With the values such as 862500 as "Value"parameter in the NPV function, it
returns "###"
Expected Results:
Should calculate NPV
Reproducible: Always
User Profile Reset: No
Additional Info:
n/a
--
You are receiving this mail because:
You are the assignee for the bug.
