Rounding up or down
=MROUND(A2,5)
Where A2 contains the value you want to round...
"Taylor" wrote:
I am working on an excel spread sheet running price costing numbers. I want
the numbers to round up to multiplies ending in 5 or 0. Example if I have a
cost of $ 122.18, I need to round to 120.00 if the the number is 124.88 I
need the number to round up 125.00.
|