I've tried that already roadkill. No go.

....thanks tho'

roadkill wrote:
How about =ROUND(B14,-2) - this assumes your number is in cell B14, of course.
Will

"rinkjustice" wrote:

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!