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
But i would like this to have a condition that it meets that pack qty of the supplier.
<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.
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
Code:
=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.