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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]max[/TD]
[TD]min[/TD]
[TD]Pack Qty[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]96[/TD]
[TD]32[/TD]
[TD]20[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]36[/TD]
[TD]12[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]36[/TD]
[TD]12[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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