Mround function

[ljoseph]

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?

[Blake 7]

=floor(a1/b1,0.2)

if 34.6 is in a1 and 5 in b1


or =Ceiling if you want to go up

[ljoseph]

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?

[6StringJazzer]

Select A1. Go to Data Validation, and under the dropdown box under "Allow" select Custom. In the formula box, put

Please Login or Register  to view this content.

Add prompts and error messages as desired.