Round to nearest 5000?
Another way:
=ROUND(A1/5000,0)*5000
159,812 165,000
That will round to 160,000
Biff
"Kim" wrote in message
...
Hi,
I have a column of values that I want to round up or down to the nearest
5000.
Is there a function for this?
Examples:
Orig Rounded
167,200 165,000
165,764 165,000
159,812 165,000
192,116 190,000
189,253 190,000
--
-Kim
|