Rounding up to 50? How?

[shadestreet]

How can I round up to the nearest 50? Say I have the number 66, I wan
that rounded to 100. 44 would be rounded to 50, etc.

Thanks

 

[Peo Sjoblom]

One way

=CEILING(A1,50)

Regards,

Peo Sjoblom

 

[Frank Kabel]

Hi
=CEILING(A1,50)

also see:
http://www.xldynamic.com/source/xld.Rounding.html

 

[Bernard Liengme]

Use =ROUND(A1/50,0)*50 to round to nearest 50 and =ROUNDUP(A1/50,0)*50 to
round UP to nearest 50.