[Libreoffice-bugs] [Bug 144274] New: Formula not working for minimum positive number... but works in Excel.
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Thu Sep 2 16:35:38 UTC 2021
https://bugs.documentfoundation.org/show_bug.cgi?id=144274
Bug ID: 144274
Summary: Formula not working for minimum positive number...
but works in Excel.
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: busysteve at gmail.com
Description:
The following formula does not work in LibreOffice but works in Excel:
To find minimum positive number....
=MIN(IF(A1:A4>0,A1:A4))
Given the following numbers:
-56
23
-9
8
The is a site that discribes this formula in detail:
https://www.extendoffice.com/documents/excel/2974-excel-find-smallest-positive-number.html
Steps to Reproduce:
1. enter the following number is cells A1 to A4
-56
23
-9
8
2. In a neighboring cell enter this formula
=MIN(IF(A1:A4>0,A1:A4))
3. If you -56 that's wrong. If you see 8 that's correct.
Actual Results:
-56 that's wrong.
Expected Results:
8 that's correct.
Reproducible: Always
User Profile Reset: No
Additional Info:
If you -56 that's wrong. If you see 8 that's correct.
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210902/ff6b9f94/attachment.htm>
More information about the Libreoffice-bugs
mailing list