I need to roundup and also rounddown

[daniboymu]

Guys, I need to Roundup a number to the nearest hundred
example: 151,52 to 200
and also I need to rounddown the number to the nearest hundred
example: 149,92 to 100
how could I do that?

 

[Joe4]

It looks like you want to round to the nearest 100.
Take a look at the MROUND function, i.e.

=MROUND(A1,100)

or

=MROUND(A1;100)

depending on your regional settings.

There are also ROUNDUP and ROUNDDOWN functions in Excel.