View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rinkjustice rinkjustice is offline
external usenet poster
 
Posts: 6
Default Formula for rounding number to nearest hundred?

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!