Need some help with my latest challenge. If in cell A2 I have a number of 50. In B2 I have a multiple of 30. Keeping a whole number, how many additional widgets do I need to make a the closest multiple of 30 (rounding up). So the answer would be 60 or 2 multiples of 30 where I have to add 10 to the original number.
If I have a number in A3 of 15 and 30 is the multiple than the answer would be 30.
I've attached a simple spreadsheet to help explain in an easier way what I need.
any help would be greatly appreciated as always.