MROUND

Definition: MROUND is a function that rounds a number to the nearest multiple of a specified value.

Syntax: =MROUND(number, multiple)

Situation: This formula is appropriate when you need to round a number to the nearest multiple of a specified value.

Example: If you have a number 13 and want to round it to the nearest multiple of 5, the formula =MROUND(13, 5) can be used, which returns 15.