Hi
use
=ROUNDUP(A1,-2)

Also see:
http://www.xldynamic.com/source/xld.Rounding.html

"sunilbhandare" wrote:


hello everyone
is it possible do round off to next hundred?
i mean say 222 i wish to make it round to 300....
sounds teriible?!!! but please help me.
thanx
sunil


--
sunilbhandare
------------------------------------------------------------------------
sunilbhandare's Profile: http://www.excelforum.com/member.php...o&userid=16691
View this thread: http://www.excelforum.com/showthread...hreadid=318987