The round function will do this. =ROUND(X,Y)
X is the number (cell reference) you want rounding
Y is the number of decimal places you want it to round to. If you want
something rounded to 3 decimal places, Y would be 3. Y can take
negative values, such as -1, which rounds to the nearest ten and -2,
which rounds to the nearest hundred, which you are after.
Assuming the cell you want rounding is F10, the equation is
=ROUND(F10,-2)


--
Faz
------------------------------------------------------------------------
Faz's Profile: http://www.excelforum.com/member.php...o&userid=27830
View this thread: http://www.excelforum.com/showthread...hreadid=476232