» Rounding Up / Down to the Nearest Multiple of a Specific Number
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: 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:
- Windows XP for Dummies
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Special Edition Using Microsoft Outlook 2002
- Investing for Dummies, Third Edition
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
No comments have been submitted.
