Formula for rounding number to nearest hundred?
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!
|