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.
Comments on A function to round negative numbers towards 0
Post
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 comment thread