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
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.
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.
GOOD FORMULA ...THANKS
Wow! Nice.
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??
Thank you so much!!!!! This formula cut down my work time by so much!
Small solution to my big problem. Thanks