Rounding A Number In Millions From A Formula

[milwphil]

Good afternoon!

If anyone can help me out how to figure this 'round' function out I'd greatly appreciate it. I'm trying to be slick when I'm not qualified to do so.

In column BW I have this formula (cell BW6):
=SUM(SOV!$AI6,SUM(SOV!$AJ6:SOV!$AO6),SUM(SOV!$AP6:SOV!$AS6))

And in BX6 I have this formula (attempting to round the results to the nearest 5 million)...however I keep getting "0":

=ROUND(BW6/5000000,0)*5000000

Once again, as in my other posts...this is probably really simple for the experts on this board, but I'm stumped!

Any suggestions?

Thanks,
Phil

 

[milwphil]

MY BAD! My example that I was working with had a couple zeros. I need more coffee. Either way, the above works....

 

[T. Valko]

Good afternoon!

If anyone can help me out how to figure this 'round' function out I'd greatly appreciate it. I'm trying to be slick when I'm not qualified to do so.

In column BW I have this formula (cell BW6):
=SUM(SOV!$AI6,SUM(SOV!$AJ6:SOV!$AO6),SUM(SOV!$AP6:SOV!$AS6))

And in BX6 I have this formula (attempting to round the results to the nearest 5 million)...however I keep getting "0":

=ROUND(BW6/5000000,0)*5000000

Once again, as in my other posts...this is probably really simple for the experts on this board, but I'm stumped!

Any suggestions?

Thanks,
Phil

Works OK for me.

Book1
	A
1	12,345,678
2	123,456
3	123,456,789
4
5	Total
6	135,925,923
7
8	Rounded
9	135,000,000
Sheet3

You can reduce the SUM formula to:

=SUM(SOV!$AI6,SOV!$AJ6:SOV!$AO6,SOV!$AP6:SOV!$AS6)