» Rounding a Value to Make It Divisible by a Specified Number
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: 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:
No comments have been submitted.
