» Rounding a Value to Make It Divisible by a Specified Number
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Rounding up each number in column A to the nearest value that makes it divisible by the corresponding number in column B.
Solution:
Use the ROUNDUP function in the following formula:
=ROUNDUP(A2/B2,0)*B2
Book Store:
Recommended Books:
- Keys to Reading an Annual Report (Barron's Business Keys)
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Marketing Management
- Excel Charts
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Accounting the Easy Way
roundup
John Nash
Found this web site and your tip on roundup. Helped me solve a problem i've been puzzling over for an hour.
