# Rounding a Value to Make It Divisible by a Specified Number

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

## Users are saying about us...

1. Small solution to my big problem. Thanks

2. Thank you so much!!!!! This formula cut down my work time by so much!

3. WHATS THE FORMULA TO MAKE A ROUNDUP VALUE (LET A6). THE RESULT SHOULD BE DIVISIBLE BY B6 BUT THE ROUND UP VALUE SHOULD BE LESS THAN A6??

4. Nikhil Namdeo Kuthe

You can use =Ceiling(A3,2) if you want the number to be multiple of 2 or =Ceiling(A3,5) if you want the number to be multiple of 5 and so on.

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.