Rounding Functions
ROUND | Returns the number rounded to a certain number of decimal places or digits. |
ROUNDUP | Returns the number rounded up to a certain number of decimal places or digits. |
ROUNDDOWN | Returns the number rounded down to a certain number of decimal places or digits. |
MROUND | Returns the number rounded to a certain multiple. |
INT | Returns the number rounded down to the nearest integer. |
TRUNC | Returns the number truncated to a number of decimal places. |
EVEN | Returns the number rounded to the nearest even integer. |
ODD | Returns the number rounded to the nearest odd integer. |
CEILING.MATH | Returns the number rounded up to the nearest integer or multiple. |
FLOOR.MATH | Returns the number rounded down to the nearest integer or multiple. |
ROUND Returns the number rounded to a certain number of decimal places or digits. |
ROUNDUP Returns the number rounded up to a certain number of decimal places or digits. |
ROUNDDOWN Returns the number rounded down to a certain number of decimal places or digits. |
MROUND Returns the number rounded to a certain multiple. |
INT Returns the number rounded down to the nearest integer. |
TRUNC Returns the number truncated to a number of decimal places. |
EVEN Returns the number rounded to the nearest even integer. |
ODD Returns the number rounded to the nearest odd integer. |
CEILING.MATH Returns the number rounded up to the nearest integer or multiple. |
FLOOR.MATH Returns the number rounded down to the nearest integer or multiple. |
CEILING.MATH
Often used in finance to round up to the nearest penny.
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext