Rounding a Value to Make It Divisible by a Specified Number http://www.exceltip.com/excel-text-formulas/rounding-a-value-to-make-it-divisible-by-a-specified-number.htmlFollow 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 Please follow and like us: 0

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?? Reply ↓

Small solution to my big problem. Thanks

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

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