Rounding to every 5th whole number

L

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.
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top