LinkBack URL
About LinkBacks
I want to SUM up numbers and MROUND in the same cell.
I'm using this formular:
Which gives me an error. How can I fix it?
Please Login or Register to view this content.
I want to SUM up numbers and MROUND in the same cell.
I'm using this formular:
Which gives me an error. How can I fix it?Please Login or Register to view this content.
See if this works
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
I figured it out.
I used this formular:
Please Login or Register to view this content.
Glad you were able to get it worked out.
Hello again,
I have a question in regards to the formula. Say I want to MROUND to the nearest 10, how would it look like then.
Here is the formular I've tried. Won't work with 10, but if I change it to 0,5, it will do just fine with that spread:
Appreciate any help.Please Login or Register to view this content.
Tell us what's in E24 and E25 and what result you expect.Originally Posted by GAPP
On a side note, you don't need the SUM function:
=MROUND(E24-E25;10)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
E24: 16.288,53
E25: 3.504,00
MROUND cell: 12.784,53 even if I apply the code you provided: =MROUND(E24-E25;10)
PS. In europe the '.' and ',' is opposite compared to US and many other places. Don't mind that.
I get a result of 12780 using both of these formulas:
=MROUND(E24-E25,10)
=ROUND(E24-E25,-1)
You may have to replace the comma with a semi-colon.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks