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