Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
A function to round negative numbers towards 0
Some while ago a user of Web Applications asked after a function to avoid "an if/else just to handle negative numbers properly".
Clarification provided was:
Presently it round based on absolute value, meaning that -1.5 rounds to -2.0, which is wrong. I want it to round to -1.0
An answer was offered:
=-ROUND(-A1-0.5,0)
but while this rounds -1.5 to -1 (and 1.5 to 2) in accordance with the sample provided, it rounds 1.0, for example, to 2 (and 5.0 to 6 etc.).
Is there a function to round -1.5 to -1 and 1.5 to 2 while rounding 1.0 to 1?
1 answer
Yes, several. Example outcomes from various inputs and functions are shown in the table below, with those compliant with the current requirement highlighted:
CEILING
CEILING.MATH
CEILING.PRECISE
0 comment threads
1 comment thread