MROUND function??

  • Thread starter Thread starter MelbourneMel
  • Start date Start date
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:
 
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:


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top