Round up to nearest 50?

DANDERSON · Sep 22nd 2004

I have numbers in my data that need to be rounded up to the neares 50.

I know how to use roundup to nearest 10, 100, etc..but that wont work with 50.

IE: 20,255 = 20,300
20,245 = 20,250

Thanks for any suggestions.

**Domenic** · Sep 22nd 2004

=CEILING(A1,50)

Hope this helps!

DANDERSON · Sep 22nd 2004

Thats it! Thank you very much!

Ceiling.....Huh, never came acrossed it, thank you.

Dave Hawley · Sep 22nd 2004

Hi DANDERSON

No need to mark threads as Solved. Simple say thanks and leave 'as is'. Thanks.

dinithi · Mar 16th 2017

Re: Round up to nearest 50?

Quote from Domenic;122617

=CEILING(A1,50)

Hope this helps!

Omg,
Thank you Domenic.

Participate now!