View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
BoniM BoniM is offline
external usenet poster
 
Posts: 353
Default 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.