LinkBack URL
About LinkBacks
Hello,
This is regarding using MROUND function in excel 2007.
I want to divide 34.6 by 5 (This is equla to 6.92) and round to multiple of 0.2 on the lower side.
With MROUND(34.6/5,0.2) gives 7 and it is rounding up. How to get this rounded to 6.8?
Hello,
This is regarding using MROUND function in excel 2007.
I want to divide 34.6 by 5 (This is equla to 6.92) and round to multiple of 0.2 on the lower side.
With MROUND(34.6/5,0.2) gives 7 and it is rounding up. How to get this rounded to 6.8?
=floor(a1/b1,0.2)
if 34.6 is in a1 and 5 in b1
or =Ceiling if you want to go up
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
Thanks... This works.
Also, I have this number 34.6 in cell A1. How to add a data validation to cell A1 so that only multiples of 0.2 can entered in cell A1?
Select A1. Go to Data Validation, and under the dropdown box under "Allow" select Custom. In the formula box, put
Add prompts and error messages as desired.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks