How do I add a formula to excel to round a number to the nearest 100?
Eg 1445 would need to be rounded down to 1400 or 1175 would become 1200?
The numbers are already integers. Floor and ceiling formula seem almost to work, but I need to to automatically round up if 50 or over and round down if 49 or under.
Thanks
Bookmarks