Description: These are possible school notes: 1.0, 1.3, 1.7, 2.0, 2.3, ..... 4.3, 4.7, 5.0. The note 2.6 needs to be rounded up to 2.7, 2.9 up to 3.0, etc. It would be nice to have a ROUND funcion like: ROUNDFREE(1;1;1.3;1.7;.....4.7;5) The first number can be 1 to round up or -1 to round down, followed by a list of individual numbers. Nice to have: the number of digits is free, like: ROUNDFREE(-1;3.3309;14.09;-19.0008) Probably you need a further parameter to decide how to handle number that is out of range, like to round 8.3 up to 5 Actual Results: Enhancement Request! Expected Results: EnhEnhancement Request! Reproducible: Always User Profile Reset: No Additional Info: Enhancement Request!
Can you change the summary to something proper? Thanks.
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
Guess a enhanced ROUND would be LibreOffice extended beyond ODF 1.4 spec for Formula provided ROUND, ROUNDUP and ROUNDDOWN [1]. =-ref-= [1] https://docs.oasis-open.org/office/OpenDocument/v1.4/csd01/part4-formula/OpenDocument-v1.4-csd01-part4-formula.html#__RefHeading__1018614_715980110