https://bugs.documentfoundation.org/show_bug.cgi?id=165136
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |WONTFIX --- Comment #2 from Mike Kaganski <[email protected]> --- Round down is easy. Cells A1:A20: 1.0, 1.3, 1.7, 2.0, 2.3, ..... 4.3, 4.7, 5.0 Formula to round down a number in cell B1: =VLOOKUP(B1;A1:A20;1;1) This can also be entered using inline arrays, without the values in A1:A20 (although this is a worse idea methodologically: having a dedicated dictionaries is a good method): =VLOOKUP(B1,{1;1.3;1.7;2;2.3;...;4.3;4.7;5},1,1) Round up can be implemented in a similar way, using XLOOKUP, available since LibreOffice 24.8; it allows to specify, if the function should return the next smaller or the next larger value. These functions provide 100% of the functionality that you are looking for. No need for dedicated "round" functions, that implement a subset of the existing functions. By the way: you did it correctly, posting your enhancement request here: we track both bugs and enhancements here, using the "severity: enhancement". Ref: https://help.libreoffice.org/latest/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152 https://help.libreoffice.org/latest/en-US/text/scalc/01/func_xlookup.html?DbPAR=CALC -- You are receiving this mail because: You are the assignee for the bug.
