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?

	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]

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