Hehe, actually my last examples round down ;)

"Martin" skrev i meddelandet
...
Please use Jerry's solution - mine always rounds up (I just saw your last
example).

"Martin" wrote:

You need CEILING:
=CEILING(9700000,1000000) rounds up to nearest million

"Andreas Håkansson" wrote:

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?