# Documentation/Calc Functions/MROUND

Other languages:

MROUND

Mathematical

## Summary:

Returns a number rounded to the nearest multiple of another number.

## Syntax:

MROUND(Number; Multiple)

## Returns:

Returns Number rounded to the nearest multiple of Multiple.

## Arguments:

Number is a real number or a reference to the cell containing that number which is to be rounded to the nearest multiple of Multiple.

Multiple is a real number or a reference to the cell containing that number whose nearest integer multiple the Number is to be rounded.

• In case the Number is negative, its absolute value is considered for multiple selection and then the sign is multiplied to the result.
• Sign of Multiple is ignored.
• In case the Number is equally close to two consecutive multiples of Multiple, i.e. it lies midway then higher absolute valued multiple is returned by the function.

An alternative implementation would be Multiple * ROUND(Number/Multiple).

## Examples:

Formula Description Returns
=MROUND(15.5;3) rounds 15.5 to nearest multiple of 3, i.e. 15.5 is closer to 15 (= 3*5) than to 18 (= 3*6) 15
=MROUND(1.4;0.5) rounds 1.4 to nearest multiple of 0.5, i.e. 1.4 is closer to 1.5 (= 0.5*3) than to 1.0 (= 0.5*2) 1.5
=MROUND(11;2) rounds 11 to nearest multiple of 2, i.e. 11 is as closer to 12 (= 2*6) as to 10 (= 2*5) so taking higher value 12
=MROUND(-11;2) rounds -11 to nearest multiple of 2 but -11 is as closer to -12 (= 2*-6) as to 10 (= 2*-5) so taking higher absolute valued multiple -12
=MROUND(-11;-2) rounds -11 to nearest multiple of 2,ignoring the sign -12
=MROUND(11;-2) rounds -11 to nearest multiple of 2, ignoring the sign 12

ROUND

## ODF standard:

Section 6.17.4, part2

MROUND
The text passage is a documentation for the MROUND function in a spreadsheet application, detailing its purpose, syntax, arguments, and providing examples of its usage.
multiple_questions_with_answers

the passage contains multiple examples that can be considered as mathematical questions, and each example is followed by an answer that explains the result of the function.
Given a text passage, determine:
    1. If it contains a mathematical question (including word problems or calculations)
    2. If an answer to that mathematical question is provided in the text

First, describe the content structure you found in 1-2 sentences.

Then provide your analysis in the following format:
TYPE: <one of the following values>
- NO_QUESTION
- SINGLE_QUESTION
- SINGLE_QUESTION_WITH_ANSWER
- MULTIPLE_QUESTIONS
- MULTIPLE_QUESTIONS_WITH_ANSWERS
system
# Documentation/Calc Functions/MROUND

Other languages:

MROUND

Mathematical

## Summary:

Returns a number rounded to the nearest multiple of another number.

## Syntax:

MROUND(Number; Multiple)

## Returns:

Returns Number rounded to the nearest multiple of Multiple.

## Arguments:

Number is a real number or a reference to the cell containing that number which is to be rounded to the nearest multiple of Multiple.

Multiple is a real number or a reference to the cell containing that number whose nearest integer multiple the Number is to be rounded.

• In case the Number is negative, its absolute value is considered for multiple selection and then the sign is multiplied to the result.
• Sign of Multiple is ignored.
• In case the Number is equally close to two consecutive multiples of Multiple, i.e. it lies midway then higher absolute valued multiple is returned by the function.

An alternative implementation would be Multiple * ROUND(Number/Multiple).

## Examples:

Formula Description Returns
=MROUND(15.5;3) rounds 15.5 to nearest multiple of 3, i.e. 15.5 is closer to 15 (= 3*5) than to 18 (= 3*6) 15
=MROUND(1.4;0.5) rounds 1.4 to nearest multiple of 0.5, i.e. 1.4 is closer to 1.5 (= 0.5*3) than to 1.0 (= 0.5*2) 1.5
=MROUND(11;2) rounds 11 to nearest multiple of 2, i.e. 11 is as closer to 12 (= 2*6) as to 10 (= 2*5) so taking higher value 12
=MROUND(-11;2) rounds -11 to nearest multiple of 2 but -11 is as closer to -12 (= 2*-6) as to 10 (= 2*-5) so taking higher absolute valued multiple -12
=MROUND(-11;-2) rounds -11 to nearest multiple of 2,ignoring the sign -12
=MROUND(11;-2) rounds -11 to nearest multiple of 2, ignoring the sign 12

ROUND

## ODF standard:

Section 6.17.4, part2

MROUND
user
The text passage is a documentation for the MROUND function in a spreadsheet application, detailing its purpose, syntax, arguments, and providing examples of its usage.

TYPE: MULTIPLE_QUESTIONS_WITH_ANSWERS

The passage contains multiple examples that can be considered as mathematical questions, and each example is followed by an answer that explains the result of the function.