Rounding to every 5th whole number

[LHS]

I have a pivot table that is giving currency values. I need a separate
column with these values rounded to the nearest fifth. For example 13,576.90
needs to round to 13,575 or 389.10 needs to round to 390.

 

[Sheeloo]

Use
=ROUND(A1,-1)

replace A1 by the reference to the cell you want to round...

 

[bpeltzer]

=mround(a1,5)

 

[Ron Rosenfeld]

I have a pivot table that is giving currency values. I need a separate
column with these values rounded to the nearest fifth. For example 13,576.90
needs to round to 13,575 or 389.10 needs to round to 390.

=ROUND(A1/5,0)*5 is one formula to use.
--ron

 

[David Biddulph]

Wouldn't that round to the nearest 10, rather than 5?