# MROUND

MROUND(number, multiple)

Returns the number rounded to the desired multiple.

 number The number you want to round. multiple The multiple to which you want to round.

 REMARKS
 * This function rounds up, if the remainder of dividing "number" by "multiple" is greater than or equal to half the value of "multiple".* This function rounds down, if the remainder of dividing "number" by "multiple" is less than half the value of "multiple".* If "number" and "multiple" have different signs, then #NUM! is returned.* You can use the CEILING.MATH function to round up to the nearest integer or significant figure.* You can use the FLOOR.MATH function to round down to the nearest integer or significant figure.* You can use the ROUND function to round to a specified number of digits.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =MROUND(10,3) = 9 2 =MROUND(-10,-3) = -9 3 =MROUND(1.58,0.5) = 1.5 4 =MROUND(1.3,0.2) = 1.4 5 =MROUND(1234,100) = 1200 6 =MROUND(1234,1000) = 1000 7 =MROUND(5,-2) = #NUM! 8 =MROUND(-5,2) = #NUM! 9 =MROUND(10,"some text") = #VALUE!

© 2022 Better Solutions Limited
{"ft_lang_label":"__label__en","ft_lang_prob":0.8065399,"math_prob":0.9928573,"size":1006,"snap":"2022-40-2023-06","text_gpt3_token_len":227,"char_repetition_ratio":0.15469062,"word_repetition_ratio":0.19375,"special_character_ratio":0.22763419,"punctuation_ratio":0.12021858,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.998911,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2022-10-06T00:05:31Z\",\"WARC-Record-ID\":\"<urn:uuid:75cc9f63-6183-4e67-9cda-144c3aacb8cc>\",\"Content-Length\":\"20383\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:834fb453-d457-4258-a5b9-bd7d9d52a8c5>\",\"WARC-Concurrent-To\":\"<urn:uuid:0fa53ec5-74f1-4e3b-803d-5e6fd6282e70>\",\"WARC-IP-Address\":\"160.153.155.173\",\"WARC-Target-URI\":\"https://bettersolutions.com/excel/functions/mround-function.htm\",\"WARC-Payload-Digest\":\"sha1:2VTJQKCYN5IFZE7UNPNO2V4OX3SIH2LM\",\"WARC-Block-Digest\":\"sha1:ZZ5MGBAWWYM2ITEXWBHRDJNADT5TGJ56\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2022/CC-MAIN-2022-40/CC-MAIN-2022-40_segments_1664030337680.35_warc_CC-MAIN-20221005234659-20221006024659-00745.warc.gz\"}"}