divides the amount of an item by how much i have across all 6 groups

**Jmesser** · 06-17-2007, 11:12 PM

I have been using excel for awhile but i have a formula that I know can be created but i cant figure it out. I have 6 groups of data i am working with. Each group has 2 sets of number. The amount of an item that i need and how much i have. I want to create a formula that divides the amount of an item by how much i have across all 6 groups. If the item i am working on needs something from all 6 groups it will tell me if i can make the item for all of it. I didn't explain well so let me put an example down
Item 1 Item 2 Item 3
Item Need/Have Need/Have Need/Have Max number produced
Product 2 10 8 16 5 0 0

If anyone can help me with the formula i need for the max number produced with up to 6 sets of data i would apprieciate it

**rylo** · 06-17-2007, 11:33 PM

Hi

Can you put up a small sample file showing some data and the expected result from that data....

rylo

**Jmesser** · 06-18-2007, 12:50 AM

Here is an example of what im looking to do, Im also using excel 2003
Note: I would like the amount that can be created area to be rounded down.

**rylo** · 06-18-2007, 01:51 AM

HI

This seems incredibly cumbersome but does it give you the correct result?

T2: =floor(MIN(IF(C2,D2/C2,MAX(A2:S2)),IF(F2,G2/F2,MAX(A2:S2)),IF(I2,J2/I2,MAX(A2:S2)),IF(L2,M2/L2,MAX(A2:S2)),IF(O2,P2/O2,MAX(A2:S2)),IF(R2,S2/R2,MAX(A2:S2))),1)

rylo