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.
Post History
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...
#2: Post edited
by
Alexei
·
2020-11-01T06:57:39Z (over 3 years ago)
replaced tags with more meaningful ones
#1: Initial revision
by
pnuts
·
2020-10-17T16:40:45Z (over 3 years ago)
A function to round negative numbers towards 0
Some while ago a user of Web Applications [asked](https://webapps.stackexchange.com/questions/139211/rounding-negative-numbers-in-g-sheets) 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`?