Round Function

[Michelle]

Help!

I'm trying to figure out which function will round a whole
number up or down to the nearest 100 without using
seperate roundup or round down function. The function or
calculation needs to be the same for all cells.

Example:

241 should round down to 200
156 should round up to 200

Any ideas?

Michelle

 

[Paul Corrado]

Michelle,

=ROUND(241,-2)

HTH

PC

 

[Thomas]

=mround(number,100)
requires analysis toolpac to be loaded in Tools -addins

 

[Ron Rosenfeld]

Help!

I'm trying to figure out which function will round a whole
number up or down to the nearest 100 without using
seperate roundup or round down function. The function or
calculation needs to be the same for all cells.

Example:

241 should round down to 200
156 should round up to 200

Any ideas?

Michelle

=ROUND(num,-2)


--ron

 

[Michelle]

Thank You....You're a lifesaver!

Michelle

-----Original Message-----
Michelle,

=ROUND(241,-2)

HTH

PC





.

 

[Michelle]

Ron,
Thank You...I can't tell you how much time you've saved
me.
Michelle

-----Original Message-----

 

[Tushar Mehta]

While you've already received an answer to your specific problem, the
general apporach to round the number m to a multiple of n is
=ROUND(m/n,0)*n. So, in your case, =ROUND(m/100)*100 would work.

One can use any meaningful function in place of ROUND -- TRUNC or INT
come to mind.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions