# How to round up or down a number in multiples of 50

##### New Member
I would like to round numbers in multiples of 50 depending on the situation.

I need to round up a number if the last two intergers are greater than 25, and I need to round down if the last two intergers are less than 25.

(Ex: 838 is to be rounded up to 850 and 815 is to be rounded down to 800)

### Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
welcome to the board!

simple solution:

=IF(RIGHT(A2,2)+0>=25,CEILING(A2,50),FLOOR(A2,50))

As in:
Book7
ABCD
1NumRounded
2308300
3383400
4363400
5449450
6397400
7120100
8110100
9184200
10391400
11315300
12
Sheet1

nice one. i was looking at something similar but couldn't get it to work because i didn't have the +0. why is there a need for coercion in this case?
thanks
anno

because right() is a text function, so the resulting 2 character text string needs to gets coerced back into a number (in this case by adding 0)

oh (slaps forehead dramatically), of course. duh.
thanks
anno

Thanks very much for your assistance on the formula.

You guys are great!

Replies
5
Views
115
Replies
3
Views
102
Replies
7
Views
311
Replies
10
Views
862
Replies
5
Views
56

1,203,534
Messages
6,055,955
Members
444,839
Latest member
laurajames

### 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