MROUND function??

[MelbourneMel]

I'm working on a spreadsheet that has hundreds of numbers that I need to
round off to the nearest 50 (ie; 137 to 150, 13402 to 13400). How do I
do this for the whole spreadsheet? MROUND doesn't seem to be doing it
for me (or user error!)

I'm writing a paper for a conference next week and any help is
appreciated.

Thanks,
Mel

 

[JohnI in Brisbane]

MM,

Try this =ROUND(A2/50,0)*50

regards,

JohnI

I'm working on a spreadsheet that has hundreds of numbers that I need to
round off to the nearest 50 (ie; 137 to 150, 13402 to 13400). How do I
do this for the whole spreadsheet? MROUND doesn't seem to be doing it
for me (or user error!)

I'm writing a paper for a conference next week and any help is
appreciated.

Thanks,
Mel

creating financial statements