Subscriber Maki K. asks \u2018in Excel how do I show $8,607 as $9,000 and $43,035 as $43,000?\u2019.\u00a0 The answer is the ROUND function.<\/p>\n
You may be familiar with the ROUND function as it is often used to round a number or the result of a calculation to two decimal places.\u00a0 So, 2.36 * 5% would give you 0.118.\u00a0 ROUND(2.36*5%, 2) gives you 0.12.<\/p>\n
You can also use a negative number as the second parameter to round to the left of the decimal point.\u00a0 So, ROUND(8607, -3) gives you 9000 and ROUND(43035,-3) gives you 43000.<\/p>\n
This can be useful if you have developed a detailed spreadsheet but want to present the numbers as a high-level budget with numbers rounded to the nearest hundred or thousand.<\/p>\n","protected":false},"excerpt":{"rendered":"
Subscriber Maki K. asks \u2018in Excel how do I show $8,607 as $9,000 and $43,035 as $43,000?\u2019.\u00a0 The answer is the ROUND function. You may be familiar with the ROUND …<\/p>\n","protected":false},"author":4,"featured_media":28,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-298","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"\n