» Rounding Up / Down to the Nearest Multiple of a Specific Number
Rounding the numbers in List1 (column A) to the nearest multiple of 50. We want to round both up and down.
To round up, use the CEILING function in the following formula:
To round down, use the FLOOR function in the following formula: