Notifications
Q&A

A function to round negative numbers towards 0

+1
−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?

Why should this post be closed?

0 comments

1 answer

+0
−0

Yes, several. Example outcomes from various inputs and functions are shown in the table below, with those compliant with the current requirement highlighted:

Rounding examples

CEILING
CEILING.MATH
CEILING.PRECISE

0 comments

Sign up to answer this question »