ROUNDUP problem

[sax]

Hi,
I have multiple entries with numbers like 68817, 35785 etc.
What I would like to do is to round up all numbers to the nearest 50 or 100, for example 68817 will be 68850 and 35785 will be 35800.
I have tried various combinations with ROUND UP and ROUND finctions but I am missing something.
Thanks in advance

 

[Richard Schollar]

Hi

try:

=CEILING(A1,50)

 

[VoG]

Try

=CEILING(A1,50)

 

[sax]

Thanks a million, works great.
I've never heard of CEILING function.
Thanks once more