MROUND function??

M

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:confused:
 
J

JohnI in Brisbane

MM,

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

regards,

JohnI

MelbourneMel said:
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:confused:
Click to expand...
creating financial statements
 
Top