Manuals/calci/ROUNDDOWN

ROUNDDOWN(number,num_digits)

• Where 'number' is the number to round and
• 'num_of_digits' is the number of digits to which the number is to be rounded.
• ROUNDDOWN(), rounds a number down, toward zero.

Description

ROUNDDOWN(number, num_of_digits)

This function is used to round a number down towards zero, to the number of decimal digits specified in the argument.

For Example,

ROUNDDOWN(67.8,0) returns 67 as a result.

ROUNDDOWN(6.83112,3) returns 6.831 as a result.

• If 'num_of_digits' is omitted, Calci displays #NaN error message.
• The number is rounded down to the specified number of decimal places, if num_of_digits > 0.
• The number is rounded down to the nearest integer, if num_of_digits = 0.
• The number is rounded down to the left of the decimal point, if num_of_digits < 0.
• If any argument is non-numeric, Calci displays #NaN error message.

ROUNDDOWN() can also be used for multiple number array as -

ROUNDDOWN(2.55..7.55,1) that rounds the numbers 2.55 to 7.55 to one decimal place.

Number Num_of_digits ROUNDDOWN
2.55 1 2.5
3.55 1 3.5
4.55 1 4.5
5.55 1 5.5
6.55 1 6.5
7.55 1 7.5
• ROUND() can be used to round a number to specified number of digits.
• ROUNDUP() can be used to round a number away from zero.
• MROUND() can be used to round a number to desired multiple.

Examples

 Function Output ROUNDDOWN(7.6712,2) 7.67 ROUNDDOWN(388.345,0) 388 ROUNDDOWN(199.37,-1) 190 ROUNDDOWN(-9.95,1) -9.9 ROUNDDOWN(-9.95,-1) 0

Related Videos

ROUNDING DECIMALS
{"ft_lang_label":"__label__en","ft_lang_prob":0.5083187,"math_prob":0.99705476,"size":1562,"snap":"2022-05-2022-21","text_gpt3_token_len":501,"char_repetition_ratio":0.20603338,"word_repetition_ratio":0.12345679,"special_character_ratio":0.33546734,"punctuation_ratio":0.17836258,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9960744,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2022-01-26T22:35:23Z\",\"WARC-Record-ID\":\"<urn:uuid:ff2ed89f-8daa-4f65-ae42-ef60f53ee949>\",\"Content-Length\":\"20293\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:2911c7e8-5deb-4fd9-bcce-0b863567f171>\",\"WARC-Concurrent-To\":\"<urn:uuid:4cc34f5e-5d9e-45f5-b3c5-b33bd55205ae>\",\"WARC-IP-Address\":\"216.117.84.203\",\"WARC-Target-URI\":\"http://wiki.zcubes.com/Manuals/calci/ROUNDDOWN\",\"WARC-Payload-Digest\":\"sha1:MVR56KMGO35KQPOXFRIM7B767YXCMONW\",\"WARC-Block-Digest\":\"sha1:T4Z3V42Y56MSC5N5AUUV4DGSVP7GZ4SL\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2022/CC-MAIN-2022-05/CC-MAIN-2022-05_segments_1642320305006.68_warc_CC-MAIN-20220126222652-20220127012652-00136.warc.gz\"}"}