It didn't work on Excel back at the learning center, and it's not
working now in OpenOffice Calc (which I've found full featured and
almost identical to Excel). If that is indeed the formula, tell me what
I've been doing wrong.


David Biddulph wrote:
"rinkjustice" wrote in message
oups.com...
I'm new to excel and I've recently encountered a problem that's even
stumped my teacher. I'm hoping one of the whizes in this forum can help
me:

Say I have a number like 5413.3375, is there a formula to round it to
the nearest hundred, which in this case would be 5400?

Thanks!

=ROUND(A1,-2)

You may need to teach your teacher how to use Excel's Help facility.
--
David Biddulph