» Rounding Up / Down to the Nearest Multiple of a Specific Number
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Rounding the numbers in List1 (column A) to the nearest multiple of 50. We want to round both up and down.
Solution:
To round up, use the CEILING function in the following formula:
=CEILING(A2,50)
To round down, use the FLOOR function in the following formula:
=FLOOR(A2,50)
Book Store:
Recommended Books:
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
