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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks