rounding in multiples of 5

[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!

 

[NH]

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

 

[Don Guillett]

try
=(ROUND(K8/5,0))*5

 

[Jason]

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

 

[rbanks]

*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

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

 

[Don Guillett]

change what sent to
=(ROUNDup(K8/5,0))*5

 

[JE McGimpsey]

Alternatively,

=CEILING(K8,5)

 

[Don Guillett]

better