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

Comments

  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.

  2. 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??

Leave a Reply

Your email address will not be published. Required fields are marked *

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.