Hi

I want to use (I think it's called) bankers rounding on a number. What I
want to do is round to the nearest whole million. So if I have

9 700 000 then it should be 10 000 000
1 500 000 then it should be 2 000 000
3 499 000 then it should be 3 000 000

if there any function in excel to do this?