https://bugs.documentfoundation.org/show_bug.cgi?id=166631
--- Comment #5 from Alfio Littletree <[email protected]> --- Welcome Steve. I tested your attachment with LibreOffice version 25.2.3.2 (X86_64). Calc do not produced zeroes with your formulas. However, reading your original formula, I realized that it can produce zero as a normal mathematical result. Indeed, in the last IF(;;) you left zero as the third argument: zero is default when omitted. This sixth case, based on the comparison conditions you originally used, occurs when a floating point CPU requires to round the binary representations of your prices. If you want to avoid zero prices, you must always use the second formula, the one you called workaround. It is mathematically different, it cannot produce zero. The only flaw with spreadsheets is that they use the same calculation tools to do monetary calculations as they do for length or weight calculations. If fixed-point cells will be added in future years, the cells where you will put your currency symbol will work as expected in your original formula. -- You are receiving this mail because: You are the assignee for the bug.
