Excel Round Function

[NDMDRB]

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?

[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]220[/TD]
[TD]=ROUND(A1,2-(1+INT(LOG10(ABS(A1)))))[/TD]
[TD]250[/TD]
[TD]250[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]270[/TD]
[TD][/TD]
[TD][/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]300[/TD]
[TD][/TD]
[TD][/TD]
[TD]750[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]400[/TD]
[TD][/TD]
[TD][/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]515[/TD]
[TD][/TD]
[TD][/TD]
[TD]1250[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]780[/TD]
[TD][/TD]
[TD][/TD]
[TD]1500[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]1260[/TD]
[TD][/TD]
[TD][/TD]
[TD]1750[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

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

=MROUND(A1+125,250)

 

[NDMDRB]

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