Rounding Down with ROUND() function
It actually looks like you're trying to get the nearest 500000. 

Look here: https://stackoverflow.com/questions/1702080/round-to-nearest-5-in-sql-server

In your case, use ROUND(value1/500000.0,0)*500000