rounding to nearest 5

[mark gardner]

I am doing a percentage chart and I need to round each number figured to the nearest 5. example...if the number is 243, then I need it to round up to 245, if the number is 129, then I need it to be rounded to 130 etc...

Can someone help me with this?

 

[T. Valko]

I am doing a percentage chart and I need to round each number figured to the nearest 5. example...if the number is 243, then I need it to round up to 245, if the number is 129, then I need it to be rounded to 130 etc...

Can someone help me with this?

Try this...

=ROUND(A1/5,0)*5

 

[MrVillareal]

Use ceiling function.

=Ceiling(A1,5)