Formula to Multiply by a cell value

[Thomo4321]

Morning,

For the life of me i can not think of a way to do this.

So im trying to set up a spreadsheet for inventory management. I have the following formula in cell E2

=IF([Average_Qty per week]>=3,[@[Average_Qty per week]]*D$1,(D$1/2)*[Average_Qty per week])

But i would like this to have a condition that it meets that pack qty of the supplier.

a	b	c
max	min	Pack Qty
96	32	20
36	12	1
36	12	5

<tbody>
</tbody>

So the above table is a snippet of what my spreadsheet is, as you can see max is set at 96. however, the pack qty is 20, so i would like max to be set at 100 using a formula.

Any help is muchly appreciated.

 

[arthurbr]

You can always try the CEILING function. If A1 = 96 CEILING(A1,20) returns 100

 

[Thomo4321]

@arthurbr Works a treat, I thought there was something simple but just couldnt put my finger on it.

Thanks