Rounding to every 5th whole number
 

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.

Rounding to every 5th whole number
 

Use
=ROUND(A1,-1)

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

"LHS" wrote:

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.

Rounding to every 5th whole number
 

=mround(a1,5)

"LHS" wrote:

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.

Rounding to every 5th whole number
 

On Thu, 2 Oct 2008 17:29:01 -0700, LHS wrote:

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

Rounding to every 5th whole number
 

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

"Sheeloo" wrote in message
...
Use
=ROUND(A1,-1)

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

"LHS" wrote:

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.