help

[sunilbhandare]

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
suni

 

[Frank Kabel]

Hi
use
=ROUNDUP(A1,-2)

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

 

[Ralph K]

ROUND(A1,-2)

 

[Ralph K]

ROUND(A1,-2)

 

[Ralph K]

round(A1,-2)

 

[rkramden]

round(A1,-2)

 

[rkramden]

round(A1,-2)

 

[rkramden]

round(A1,-2)