Rounding to numbers other than 1, 10, 100 etc

If you want to round a number to a number such as say 50, you can simply set up a cell that takes the number you want to round (say 24), divide it by the number you want to round to (in this case 50 giving 0.48 ).

Then you perform the round you want, e.g. a normal ROUND will give you a 0, a ROUNDDOWN will give you a 0 and a ROUNDUP will give you a 1.

Once you have this number you can then multiple by the rounding number (50) and you will have your original number rounded to multiples of 50.

Full time equivalent calculations in Excel