Round a figure to the nearest / highest 10,100,500 etc.

    Browse: Home / Round a figure to the nearest / highest 10,100,500 etc.

If the number is in A2 just use this formula

To round to the NEAREST 500:   (eg. 524 rounds to 500)
=ROUND(A2/500,0)*500

To round to the NEXT HIGHEST 500:   (eg. 524 rounds to 1000)
=CEILING(A2,500)

«
»