Printable View
I have the following formula to round to nearest 5
=ROUND(MROUND($B$24,5)*Percentages!$B$2,0)
However i get the following asnswers
59
68
77
These should be
60
70
75
It would be appreciated if you could assist me
http://www.mrexcel.com/forum/excel-q...ng-values.html
Why don't you do an MROUND on top of the inner MROUND also?
=MROUND(MROUND($B$24,5)*Percentages!$B$2,5)
Thanks for the help, much appreciated
Answers by themselves tell us nothing... so that we can see what is going on, can you tell us what values were in cells B2 and B24 when your formula gave 59 as the answer instead of 60 and when it gave 68 instead of 70 and when it gave 77 instead of 75?Quote:
Originally Posted by Howardc
As a side question... I see you cross-posted your question on the MrExcel forum... have you been having trouble staying connect on the MrExcel forum? Most of my attempts to see the MrExcel forum meet with either a forever spinning busy icon (while a "waiting for MyExcel.." message is displayed) or I get an outright "Page Not Available" error. Once, when I managed to connect with the "root" forum page, it showed 2200 visitors logged on (that is pretty much there standard average) but I could not connect with it after refreshing the webpage. That led me to think the problem was in my computer, but I have no trouble with any other forums or webpages which, of course, makes me suspect the MrExcel forum itself. Since I know you were on earlier, I figured you could tell me if you had problems with the MrExcel forum or not?
I have! Not sure why though. And it only seemed to be that forum alone.Quote:
Originally Posted by Rick Rothstein
Thanks for the confirmation. The thing that had me worried was the number of visitor to the Excel sub-forum. Sometimes when I am having trouble getting on MrExcel's Excel sub-forum, I am able to go to MrExcel's main page (www.mrexcel.com) and from there click the "Message Forum" link and it takes me to the "root" webpage for all the sub-forums... on that root page, it showed 2000+ visitors one time, 2200+ visitors another and 1600+ a third time... that would mean those many people were successfully visiting the Excel sub-forum and yet I could not connect for anything. That is what made me start wondering if the problem was somehow in my system; but, as you said, no other websites of forums were giving me this level of problem. Anyway, if you were experiencing the same kind of problem, then it most surely is something with their forum and not my computer. Thanks again for the confirmation.Quote:
Originally Posted by Excel Fox
Hi Rick
I battled to access the Mr Excel.com site and could not post the link that I had cross posted
I see this morning that someone has repllied, but nevertheless please find my attachment
That certainly didn't need the formula I posted above. This should do
=MROUND($B$1*Percentages!B2,5)
Thanks for the help, much appreciated