View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Rounding Up to the 50

On Feb 17, 10:10*am, Lady Excel
wrote:
Are there any functions which will round numbers up
to the nearest 50? eg. 50, 100, 150, 200, etc.


You subject line says "round up to 50", which is different from "round
to the nearest 50". Which is it?

One way to round to the nearest 50:

=mround(A1,50)

If you get a #NAME? error, use Excel Help to find information on how
to use the MROUND function.

Alternatively:

=round(A1/50,0)*50

That also makes it easy to round up or down to a multiple of 50:

=roundup(A1/50,0)*50

=rounddown(A1/50,0)*50

One of those solutions should work for you.