# 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

1. 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.

• HARSHWARDHAN GAWANDE

GOOD FORMULA ...THANKS

2. Wow! Nice.

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. Thank you so much!!!!! This formula cut down my work time by so much!

5. Small solution to my big problem. Thanks

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.