Round Up to the Next 20
April 17, 2018 - by Bill Jelen
Sandy works for a construction company. They sell flooring in packages of 20 Board Feet. When their estimators go to a job, they might say that they need 441 board feet of material. Sandy needs a way to always round up to the next 20.
As I was trying to solve this at one of my live Power Excel seminars, several functions flashed through my head:
The simplest rounding function is
ROUND(Number to Round,Digits). To round something to dollars and cents, you would use
=ROUND(A2,2). To round to whole dollars, you could use
=ROUND(A2,0). What most people don't realize is that you can use ROUND to round to the nearest hundred or thousand. Instead of rounding to 2 digits, you could round to -2 digits and you would get the number in A2 rounded to the nearest 100. Or,
=ROUND(A2,-3) would round to the nearest thousand.