Rounding Functions

ROUNDReturns the number rounded to a certain number of decimal places or digits.
ROUNDUPReturns the number rounded up to a certain number of decimal places or digits.
ROUNDDOWNReturns the number rounded down to a certain number of decimal places or digits.
MROUNDReturns the number rounded to a certain multiple.
INTReturns the number rounded down to the nearest integer.
TRUNCReturns the number truncated to a number of decimal places.
EVENReturns the number rounded to the nearest even integer.
ODDReturns the number rounded to the nearest odd integer.
CEILING.MATHReturns the number rounded up to the nearest integer or multiple.
FLOOR.MATHReturns 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