# I need to roundup and also rounddown

#### daniboymu

##### Board Regular
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?

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### Joe4

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

Excel Formula:
``=MROUND(A1,100)``
or
Excel Formula:
``=MROUND(A1;100)``

There are also ROUNDUP and ROUNDDOWN functions in Excel.

Replies
0
Views
128
Replies
4
Views
186
Replies
1
Views
93
Replies
5
Views
132
Replies
6
Views
90

1,147,747
Messages
5,742,960
Members
423,767
Latest member
dafydd_jwc

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back