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

=-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 does this post require moderator attention?
Why should this post be closed?

#### 1 comment

Rounding towards 0, whether the input value is positive or negative, is simply a truncation. Olin Lathrop‭ 23 days ago

+1
−0

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

Why does this post require moderator attention?