Rouding to the nearest 50 1

[jdgonzalez]

I'm hoping someone in the community can help me out with a problem I'm having. I'm trying to create a UDF that will round off a number to the nearest 50. I took a look at BOL using the round() function, but it doesn't do what I need it to.

Ex. 123.43 = 100 or 127.00 = 150.

Any help provided would be greatly appreciated.

J.D.

 

[donutman]

Round(TheField/50,0)*50
-Karl

 

[jdgonzalez]

Worked like a charm. Thanks!