Reference: Worksheets Rounding Functions
Worksheets supports the same rounding functions as other popular spreadsheet applications. These tables can help you decide when to use each one.
Rounding a Number to an Integer
Function | Rounds... | For Positive Numbers | For Negative Numbers |
|---|---|---|---|
EVEN | Away from zero to next even number | Result becomes more positive | Result becomes more negative |
ODD | Away from zero to next odd number | Result becomes more positive | Result becomes more negative |
INT | Down to next integer below | Result becomes more negative | Result becomes more negative |
Rounding a Number Using Decimal Places
Function | Rounds... | For Positive Numbers | For Negative Numbers |
|---|---|---|---|
ROUND | Up or down to the closest value, based on the number of decimal places you specify | Result becomes more positive or negative based on the closest value | Result becomes more positive or negative based on the closest value |
ROUNDUP | Away from zero, based on the number of decimal places you specify | Result becomes more positive | Result becomes more negative |
ROUNDDOWN and TRUNC | Toward zero, based on the number of decimal places you specify | Result becomes more negative | Result becomes more positive |
Rounding a Number Using a Multiple of Significance (MoS)
Function | Rounds... | For Positive Numbers with a Positive MoS | For Positive Numbers with a Negative MoS | For Negative Numbers with a Positive MoS | For Negative Numbers with a Negative MoS |
|---|---|---|---|---|---|
CEILING | Away from zero, based on the MoS you specify | Result becomes more positive | Not applicable (#NUM error) | Result becomes more negative | Result becomes less negative |
CEILING.PRECISE and ISO.CEILING/ ISOCEILING | Up, based on the MoS you specify | Result becomes more positive | Result becomes more positive | Result becomes less negative | Result becomes less negative |
CEILING.MATH | Up, based on the MoS you specify | Result becomes more positive | Result becomes more positive | Result becomes less negative (or use mode to reverse it) | Result becomes less negative (or use mode to reverse it) |
FLOOR | Towards zero, based on the MoS you specify | Result becomes less positive | Not applicable (#NUM error) | Result becomes less negative | Result becomes more negative |
FLOOR.PRECISE | Down, based on the MoS you specify | Result becomes less positive | Result becomes less positive | Result becomes more negative | Result becomes more negative |
FLOOR.MATH | Down, based on the MoS you specify | Result becomes less positive | Result becomes less positive | Result becomes more negative (or use mode to reverse it) | Result becomes more negative (or use mode to reverse it) |
MROUND | Up or down, based on the MoS you specify | Result becomes more positive or negative, based on the closest multiple | Not applicable (#NUM error) | Result becomes more positive or negative, based on the closest multiple | Not applicable (#NUM error) |