rounding in multiples of 5

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

Hi,

How do I ensure the cell content is always a multiple of 5 without running a
macro? I currently have the following formula in the cell, which only works
to modify if the contents are below 5:

=IF(C6>0,IF(C16+C17<5,5,MROUND(C16+C17,5)),0)

Can someone help?

Thanks!
 
USe data validation on cells where you want the user to enter the values
that are multioples of 5 by selecting Custom and entering the following: -
=MOD(A1,5)=0
If the result is not zero it will give an error message
 
Ok, perhaps I should be more clear...

If the number is between 1 and 5 I need the cell to show 5
if the number is between 6 and 10 I need the cell to show 10
if the number is between 11 and 15 I need the cell to show 15
etc etc etc.

Jason
 
Jason said:
*Ok, perhaps I should be more clear...

If the number is between 1 and 5 I need the cell to show 5
if the number is between 6 and 10 I need the cell to show 10
if the number is between 11 and 15 I need the cell to show 15
etc etc etc.

Jason
Click to expand...

Don gullet's answer works best. That's what I would do.
 
Back
Top