# 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`

?

## 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:

CEILING

CEILING.MATH

CEILING.PRECISE

## 0 comments