# Round

This chapter illustrates three functions to round numbers in Excel. The ROUND, ROUNDUP and ROUNDDOWN function.

Before your start: if you round a number, you lose precision. If you don't want this, show fewer decimal places without changing the number itself.

### Round

The ROUND function in Excel rounds a number to a specified number of digits. The ROUND function rounds up or down. 1, 2, 3 and 4 get rounded down. 5, 6, 7, 8 and 9 get rounded up.

1. For example, round a number to three decimal places. Note: 114.7261, 114.7262, 114.7263 and 114.7264 get rounded down to 114.726 and 114.7265, 114.7266, 114.7267, 114.7268 and 114.7269 get rounded up to 114.727.

2. Round a number to two decimal places. 3. Round a number to one decimal place. 4. Round a number to the nearest integer. 5. Round a number to the nearest 10. 6. Round a number to the nearest 100. 7. Round a number to the nearest 1000. 8. Round a negative number to one decimal place. 9. Round a negative number to the nearest integer. ### RoundUp

The ROUNDUP function in Excel always rounds a number up (away from zero). 1, 2, 3, 4, 5, 6, 7, 8 and 9 get rounded up.

1. For example, round a number up to three decimal places. Note: 114.7261, 114.7262, 114.7263, 114.7264, 114.7265, 114.7266, 114.7267, 114.7268 and 114.7269 get rounded up to 114.727.

2. Round a number up to two decimal places. 3. Round a number up to one decimal place. 4. Round a number up to the nearest integer. 5. Round a number up to the nearest 10. 6. Round a number up to the nearest 100. 7. Round a number up to the nearest 1000. 8. Round a negative number up to one decimal place. Note: remember, the ROUNDUP function rounds a number up (away from zero).

9. Round a negative number up to the nearest integer. Note: again, the ROUNDUP function rounds a number up (away from zero).

### RoundDown

The ROUNDDOWN function in Excel always rounds a number down (toward zero). 1, 2, 3, 4, 5, 6, 7, 8 and 9 get rounded down.

1. For example, round a number down to three decimal places. Note: 114.7261, 114.7262, 114.7263, 114.7264, 114.7265, 114.7266, 114.7267, 114.7268 and 114.7269 get rounded down to 114.726.

2. Round a number down to two decimal places. 3. Round a number down to one decimal place. 4. Round a number down to the nearest integer. 5. Round a number down to the nearest 10. 6. Round a number down to the nearest 100. 7. Round a number down to the nearest 1000. 8. Round a negative number down to one decimal place. Note: remember, the ROUNDDOWN function rounds a number down (toward zero).

9. Round a negative number down to the nearest integer. Note: again, the ROUNDDOWN function rounds a number down (toward zero).

Go to Next Chapter: Formula Errors   |   Become an Excel Pro: 300 Examples
{"ft_lang_label":"__label__en","ft_lang_prob":0.689453,"math_prob":0.995805,"size":2663,"snap":"2019-26-2019-30","text_gpt3_token_len":801,"char_repetition_ratio":0.25272658,"word_repetition_ratio":0.5744235,"special_character_ratio":0.35561398,"punctuation_ratio":0.23809524,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9987701,"pos_list":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54],"im_url_duplicate_count":[null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2019-07-21T19:21:04Z\",\"WARC-Record-ID\":\"<urn:uuid:6695df15-061f-4b3a-9a92-a89e16e2787a>\",\"Content-Length\":\"18992\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:7c24d5f5-4e18-44a4-8fc6-0f4bc9fe2897>\",\"WARC-Concurrent-To\":\"<urn:uuid:33b05efd-4138-4303-9ba2-36ac1be352ef>\",\"WARC-IP-Address\":\"185.87.187.11\",\"WARC-Target-URI\":\"https://www.excel-easy.com/functions/round.html\",\"WARC-Payload-Digest\":\"sha1:N7FPWUUC5GZ2PRGOPTOHJJOJQ5TWA2HO\",\"WARC-Block-Digest\":\"sha1:NEOP3RCMDJTODTNER2JFMVFPZH6A23QP\",\"WARC-Identified-Payload-Type\":\"application/xhtml+xml\",\"warc_filename\":\"/cc_download/warc_2019/CC-MAIN-2019-30/CC-MAIN-2019-30_segments_1563195527196.68_warc_CC-MAIN-20190721185027-20190721211027-00444.warc.gz\"}"}