Spy Journal 3.0 - Comments for "Excel Function of the Week - ROUND"
https://www.spyjournal.biz/excel/ROUND
Comments for "Excel Function of the Week - ROUND"en=IF(OR(A2>=1,A2<0),A2,ROUNDUP
https://www.spyjournal.biz/excel/ROUND#comment-2113
<p>=IF(OR(A2>=1,A2<0),A2,ROUNDUP(A2,0)) - where a2 is the cell with the value in it</p>
Thu, 13 Dec 2012 22:32:28 +0000jethrocomment 2113 at https://www.spyjournal.bizI have to calculate the
https://www.spyjournal.biz/excel/ROUND#comment-2112
<p>I have to calculate the percentage of miles driven in each state by our fleet of trucks.<br />
I currently have all the totals and get the percentage of the total. I now have percentage totals that are less then 1 ie. .0007 & .014 How would I round a cell with a total greater then 0.00 but less then 1.00 up to 1.00 and leave any cell that is greater then 1.00 alone.</p>
Thu, 13 Dec 2012 15:40:40 +0000Anoncomment 2112 at https://www.spyjournal.bizor if you and i both read the
https://www.spyjournal.biz/excel/ROUND#comment-1974
<p>or if you and i both read the post again - you will note this very simple solution</p>
<p>To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function.</p>
<p>so =MROUND(SUM(A1:A6),0.05)</p>
<p>also int he above other forumla - should u want to use it - there needs to be an = sign included in the first < </p>
<p>=IF(MOD(MOD(ROUND(SUM(A1:A6),2),1),0.05)<=0.02,ROUND(SUM(A1:A6),2)-MOD(MOD(ROUND(SUM(A1:A6),2),1),0.05),ROUND(SUM(A1:A6),2)+(0.05-MOD(MOD(ROUND(SUM(A1:A6),2),1),0.05)))</p>
Tue, 28 Aug 2012 22:29:27 +0000jethrocomment 1974 at https://www.spyjournal.bizHi Kim - you need to combine
https://www.spyjournal.biz/excel/ROUND#comment-1973
<p>Hi Kim - you need to combine several formulas - SUM and ROUND.<br />
Heres an example =ROUND(SUM(A1:A5),2) will round to nearest 1 cent. getting it to nearest 5 cents involves using the MOD function and an IF Statement.<br />
(more on the MOD function here <a href="http://www.spyjournal.biz/node/951" title="http://www.spyjournal.biz/node/951">http://www.spyjournal.biz/node/951</a> )</p>
<p>here is a very complicated formula i made up to do this - i am sure someone with some time can come up with a less complex one</p>
<p>=IF(MOD(MOD(ROUND(SUM(A1:A6),2),1),0.05)<0.02,ROUND(SUM(A1:A6),2)-MOD(MOD(ROUND(SUM(A1:A6),2),1),0.05),ROUND(SUM(A1:A6),2)+(0.05-MOD(MOD(ROUND(SUM(A1:A6),2),1),0.05)))</p>
<p>basically it says if the divisor after rounding to two decimal places is 0,1 or 2 cents then it subtracts it, if its over it adds the difference between 5 cents and the divisor.</p>
<p>cheers<br />
Tim</p>
Tue, 28 Aug 2012 22:24:49 +0000jethrocomment 1973 at https://www.spyjournal.bizI have huge financial
https://www.spyjournal.biz/excel/ROUND#comment-1972
<p>I have huge financial spreadsheets & want to round a RANGE of cells to the nearest 5.<br />
I can't find a formula for that??</p>
<p>Thanks,<br />
Kim</p>
Tue, 28 Aug 2012 16:18:36 +0000Anonymouscomment 1972 at https://www.spyjournal.bizIt such a good informative
https://www.spyjournal.biz/excel/ROUND#comment-1721
<p>It such a good informative article</p>
Mon, 28 Nov 2011 13:29:01 +0000power wheels jeepcomment 1721 at https://www.spyjournal.bizExcel tips and Excel help
https://www.spyjournal.biz/excel/ROUND#comment-1699
<p>Excel tips and Excel help from the MrExcel Message Board regarding ... This formula always returns the Monday of the week in question (you can check .... In A4 enter: =DATE(A2,ROUND(A1/4,0),1)+IF(2<WEEKDAY(DATE(A2).</p>
</weekday(date(a2).</p></p>Thu, 20 Oct 2011 22:34:53 +0000Carbon CopyProcomment 1699 at https://www.spyjournal.bizalmost read all post related
https://www.spyjournal.biz/excel/ROUND#comment-1688
<p>almost read all post related Excel because Excel is my favorite subject.<br />
I'm bed pardon your round explanation.</p>
Tue, 27 Sep 2011 08:57:00 +0000heimanncomment 1688 at https://www.spyjournal.bizTry
=Roundup(A1;-1)
https://www.spyjournal.biz/excel/ROUND#comment-1155
<p>Try<br />
=Roundup(A1;-1)</p>
Mon, 28 Sep 2009 17:05:34 +0000Anonymouscomment 1155 at https://www.spyjournal.bizSchool has taught me it
https://www.spyjournal.biz/excel/ROUND#comment-653
<p>School has taught me it should be 840.<img src="http://s289006349.onlinehome.us/blank.gif" width="1px" height="1px" border="0" alt="The investor's goal in Forex trading is to profit from foreign currency ... (also called an open position) is a trade in which a trader has bought or sold at a profit." /><a href="http://www.forexmarkettrader.net"><img src="http://s289006349.onlinehome.us/blank.gif" width="1px" height="1px" border="0" alt="forex trader" /></a><img src="http://s289006349.onlinehome.us/blank.gif" width="1px" height="1px" border="0" alt="Forex Trading Course, become a successful FOREX trader. A proper FOREX education is your way to profitable foreign currency trading." /></p>
Fri, 24 Jul 2009 04:41:13 +0000Zorancomment 653 at https://www.spyjournal.biz