tag:blogger.com,1999:blog-1869924468172210809.post2065083580654121878..comments2024-03-22T10:09:26.517+00:00Comments on Not Just Numbers: Excel Tip: Rounding NumbersGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-1869924468172210809.post-26257088910046693512015-02-18T10:17:27.492+00:002015-02-18T10:17:27.492+00:00Thanks Kevin.
Thanks Kevin.<br /><br />bikash mohantyhttps://www.blogger.com/profile/00584161223489359161noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-12876051107728968772015-02-18T07:21:02.660+00:002015-02-18T07:21:02.660+00:00Bikash
Just use the ROUNDUP function on those num...Bikash<br /><br />Just use the ROUNDUP function on those numbers you want to round up.<br /><br />=ROUNDUP (10.7,0)+ROUNDUP (25.7,0)+24.4+25Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-39141434437960367232015-02-18T05:42:44.076+00:002015-02-18T05:42:44.076+00:00please advise me to how to add non-roundup decimal...please advise me to how to add non-roundup decimal cell with round up decimal cell which result will be shown in non roundup format and also the result will be display as the sum after the roundup not the result calculate by the excel as its done exactly.<br /><br />I want the exact formula for solving for e.g.<br /><br />add. Result of 10.7+25.7+24.4+25=85.8(as excel done)<br /><br />but i want the ans as 11(round up 10.7)+26(round up 25.7)+24.4(non-round up )+25(non-round up)=86.4(non-round up) rather than 85.8 or 86.<br /><br />urgently revert soonbikash mohantyhttps://www.blogger.com/profile/00584161223489359161noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-68612502483273889462014-03-05T05:05:09.327+00:002014-03-05T05:05:09.327+00:00The examples are very useful & helps understan...The examples are very useful & helps understand the tip better.Thanks to all.Ashithttps://www.blogger.com/profile/04356613687283700996noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-15003127437122612122013-07-21T00:17:14.372+01:002013-07-21T00:17:14.372+01:00I too was unaware of the MROUND function. Quickly...I too was unaware of the MROUND function. Quickly reviewing it, for the most part it seems to be the inverse of ROUND. That is to say, =ROUND(A1,2) will yield the same result as =MROUND(A1,.01), which is rounding to the nearest penny. Likewise, =ROUND(A1,-2) will yield the same result as =MROUND(A1,100), which is rounding to the nearest hundred.<br /><br />Where MROUND will shine is when you want to round to a value other than a multiple of 10, which I have needed to do on occasion. Let's say I wanted to round to the nearest 40. Before the happy discovery of MROUND, I would have used =ROUND(A1/4,-1)*4. The simpler formula is MROUND(A1,40).Ken Masonhttp://www.linkedin.com/in/kenmason13/noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-58758003387447030052013-07-17T08:21:49.011+01:002013-07-17T08:21:49.011+01:00Thanks Kevin
To be honest, I wasn't aware of ...Thanks Kevin<br /><br />To be honest, I wasn't aware of MROUND until a reader pointed it out as a comment on this post in a LinkedIn group.<br /><br />There's always more to learn!<br /><br />It looks very useful, and I think I might cover it in a future postGlen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-11720622146414976242013-07-17T07:21:28.458+01:002013-07-17T07:21:28.458+01:00For many practical purposes, I find MROUND to be m...For many practical purposes, I find MROUND to be more useful than ROUND. Thanks.Kevin Carternoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-51889557895970077382013-07-16T14:37:17.527+01:002013-07-16T14:37:17.527+01:00With the example, that's really useful to know...With the example, that's really useful to know, Paul LynamAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-67547842525378649972013-07-16T14:32:26.433+01:002013-07-16T14:32:26.433+01:00Anonymous
Sorry it hasn't come across as clea...Anonymous<br /><br />Sorry it hasn't come across as clear.<br /><br />Typically "Number" will be a calculation, rather than a direct reference to a number.<br /><br />Example:<br /><br />If cell A1 was to contain a number, let's say 20, and cell B1 was to include the formula:<br /><br />=A1/3<br /><br />and the number format in cell B1 was set to 2 decimal places.<br /><br />B1 would display 6.67<br /><br />but, if you were to use B1 in a formula, the value of B1 is actually 6.666666666666666666666666666666.... and this is what would be used in the calculation.<br /><br />If we replaced the formula in cell B1 with:<br /><br />=ROUND(A1/3,2)<br /><br />The value held in cell B1 (and used in any calculations) would actually be 6.67.<br /><br />Does that help?Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-73829455230774123512013-07-16T14:01:36.526+01:002013-07-16T14:01:36.526+01:00An example would be useful.An example would be useful.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-82233356893253571602013-07-16T13:52:02.565+01:002013-07-16T13:52:02.565+01:00Rather unclear, quite frankly. No idea how to use ...Rather unclear, quite frankly. No idea how to use this in pratical terms. Can number be a cell reference? Must the unrounded number appear on the spreadsheet in addition to the rounded number?Anonymousnoreply@blogger.com