Talk:Documentation/Calc Functions/MROUND
olivier
Check sentence:
"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."
--Olivier Hallot 2020-09-22T11:31:14 (UTC)
SF Review comments
- (1) Summary. Would it be correct to insert the word “integer” before “multiple”?
- (2) Returns. Should this state that a real number is returned? Again, maybe insert “integer” before “multiple”.
- (3) Arguments. The three bullet points left me confused. Firstly, the grammar used is not clear. Secondly, are they attempting to described additional detail of how the function works? If so, maybe they should be moved to the Additional details section?
- (4) Additional details. I do not understand this statement. I believe that the ROUND() function takes two parameters, not one number divided by another.
- (5) Examples. Please correct grammar of “is as closer”.
--Stevefanning (talk) 2020-09-26T13:46:31 (UTC)
Ronnie
- The last statement in the argument section is made grammatically correct now.
- The grammar in examples is handled as well.
- About the integer output, the function does return non-integer output so I guess it would be wrong to add integer in that case.
- About ROUND() the idea was if Number/Multiple the value will first be divided and the non-integer part will be truncated by round further multiplying with Multiple gives the nearest multiple of Multiple for that Number. The same thing is there in help section as well.
-- RonnieGandhi 2020-09-29T09:42:31 (UTC)