https://bugs.documentfoundation.org/show_bug.cgi?id=100475
Bug ID: 100475
Summary: :calculation error
Product: LibreOffice
Version: 5.0.6.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: tedwa...@gmail.com
The following are the contents of the cells producing an error:
b72:7,093
b73:97,686
b74:lessor of above 2 or 7,093
b79, 14% of b74 does not equal 13,676 it should be 993
The problem seems to be related to the test of cells b72 and b73.
b72: 7,093 =0.75*D22 this is correct
b73: 97,686 =C69*0.25 this is correct
b74: 7,093 =IF(B72<B73,B72,B73) this is correct (least of above 2 amounts)
Noted here: I received an error code complaining about number of iterations not
being set so I set interations to 25 and error went away and the resulting test
worked properly.
What I didn't notice was:
b79: =0.14*B74 produced 13,676 which is incorrect it should be 993
Fortunately the amount was great enough in difference it was easily spotted.
If I go into cell b74 and set it to equal b72 (7,093) then the calculation
works correctly. Cell b79 now equals 993.
The problem seems to be associated with the test in b74.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
