Formula to find possible combinations

[cc30729]

What formula can I use/write to find the number of Product X that I can create based on my Inventory of Item A, B, and C? To make 1 Product X, I need 1 Item A, 1 Item B, and 2 Item C.

(example A=2, B=3, C=5, I could make 2 Product X after which I would have 0 Item A left, 1 Item B left, and 1 Item C left.)

Is there a formula I can use/create to determine how many X I can create based on my inventory of A, B, and C.

Thanks, for any help.

Christopher

 

[macropod]

If you have a count of the items in columns A, B and C on row 100, and you need one of each item for your inventory, then surely the number of sets you can make is equal to the minimum of A, B and C.

A formula you could use for that is:

=MIN(A100,B100,C100)

If you need one of item A, two of item B and 3 of item C, your formula might look like:

=MIN(A100,INT(B100/2),INT(C100/3))

Cheers