» 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:
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Microsoft Windows XP Registry Guide
- The One Page Business Plan: Start With a Vision, Build a Company!
- PowerPoint® 2002 For Dummies®
- A Mathematician Plays the Stock Market
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
