Lowest multiple greater than given number

[huddsterrier]

Hi, I'm struggling coming up with a working formula for what I need, i can work out the answer in my head just can't put it in a formula for others to use. I will give you a simple example for the issue I am faced with and hope someone can help.

"You have 6 different flavours of crisps

You want to make a new set which each contains 1 of each flavour, but you don’t want any left over.

So you have to make 6 full sets at a time.

If someone ordered 11 you would have to make 12 full sets."


Data I have on the spreadsheet is

Multiples to order - Cell C3
Amount ordered - Cell D3


The formula i need is the lowest multiple of C3 that is greater than D3. in cell E3

Thanks in advance

 

[VBA Geek]

try:

Book1
	A	B	C	D	E	F	G
1
2
3			6	11	12
4
5
6
Sheet4

Cell Formulas
Range	Formula
E3	=CEILING(D3,C3)

 

[huddsterrier]

Thank you so much, I have never heard of that function before.