Need Help Making Inventory Related Table

[saff21]

To get straight to the point, I need help making a table where I can input the amount of materials I have and it then calculating how much of a particular product I can make with that. So for example. if it takes 4 of material A, 4 of material B, and 2 of material C to make one product, how can I set it up to where I can input how much of each material I currently have and it then telling me how much total product I can make?

[etaf]

you couild just use Min of the three numbers divided by the Factors
and take the integer of the lowest divided amount

so if you have in a fixed cell the amount needed
Product A = 4 in cell A1
Product B = 4 in cell A2
Product C = 2 in cell A3

And you input the amounts you have in B1,B2,B3 for each product

then
=INT(MIN( B1/A1, B2/A2, B3/A3))

there maybe a better way to get the lowest divisible amount - using MOD or something
but off the top of my head