MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Rounding


Posted by Dixie on January 24, 2002 10:05 AM

I am looking for a way to tell excel to round a number to the thousands.. for example..
32500.00 I need it to round just to the number of 32000.00 and then be able to multiply that number by another number..

Any Suggestions?????

Thanks in advance...


Posted by Steve Hartman on January 24, 2002 10:08 AM

=ROUND(32500.00,-3)

Posted by Dixie on January 24, 2002 10:15 AM

Thank You