# Excel Round Function

#### NDMDRB

##### Board Regular
Hello,

I have an inquiry regarding round function and not sure if there is a solution or not

The numbers in Column "A" are depends on some calculations

What I need is to round the numbers in Column "A" to be only as the numbers in Column "D" (looks like (250, 250*2, 250*3, 250*4...))

I used the function in "B1" and changed the numbers and tried so hard to have a result as in "C1" but didn't get what I need

Any suggestions?

 A B C D 1 220 =ROUND(A1,2-(1+INT(LOG10(ABS(A1))))) 250 250 2 270 500 3 300 750 4 400 1000 5 515 1250 6 780 1500 7 1260 1750

<tbody>
</tbody>

#### Rick Rothstein

##### MrExcel MVP
I think this formula may do what you seem to be indicating you want...

=MROUND(A1+125,250)

#### NDMDRB

##### Board Regular
Thank you so much Rick Rothstein, it works like a magic

1,081,677
Messages
5,360,451
Members
400,586
Latest member
Minty

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...