Rounding to nearest 50 using excel?

[jackoh]

Possible? If so, how?

Thanks for any help

 

[jackoh]

Quick google has shown up how to round up to the nearest 100, if anypones interested here's the link. Don's please lock thread

http://www.mrexcel.com/td0046.html

 

[Visage]

Possible? If so, how?

Thanks for any help

Divide by 50, round to the nearest number, then multiply by 50.

 

[Jotun]

=ROUND(A1/50,0)*50