Good day,

Please help. I would like to get a formula for the following.

The boxes can take the folling weight as maximum.

(A) 50 (B) 45 (C) 30

If I give a total of 130 it should give me 2 X A and 1 X C.

Thanks

Hi,

If you have "50" in A1, "45" in B1, "30" in C1 and your target ("130") in A3

then the following works but it's a bit horrible:

=INT(A3/A1) & "*A+" & INT((A3-INT(A3/A1)*A1)/B1) & "*B+" &

INT((A3-INT(A3/A1)*A1-(INT((A3-INT(A3/A1)*A3)/B1)))/C1) & "*C"

If you have "50" in A1, "45" in B1, "30" in C1 and your target ("130") in A3

then the following works but it's a bit horrible:

=INT(A3/A1) & "*A+" & INT((A3-INT(A3/A1)*A1)/B1) & "*B+" &

INT((A3-INT(A3/A1)*A1-(INT((A3-INT(A3/A1)*A3)/B1)))/C1) & "*C"

I haven't used it too much, but I think the Scenario tool will give you just

the answer you're looking for...

the answer you're looking for...

> number to fit the best?

Hi. You have {50,45,30}, and your solution to 130 is as given {2,0,1}

What if you have multiple solutions...say 180?

{0, 0, 6} or {0, 2, 3} or {0, 4, 0} or {3, 0, 1}

= = = = =

Dana DeLouis

The actual idea are to use the least boxes. Lets say A can take 50kg, B 45kg

and C 30kg. So I would like to use only 3 boxes as it works out on 2 x A and

1 X C.

Thx

and C 30kg. So I would like to use only 3 boxes as it works out on 2 x A and

1 X C.

Thx

You may try also this approach:

Suppose a total value is in A1, A value is in B1, B value is in C1 and

C value is in D1.

Then:

in B3 enter formula =A1

in C3 enter formula =MOD(B3,B1)

in D3 enter formula =MOD(C3,C1)

Finally, to get an output :

in B2 enter formula =INT(B3/B1) and copy it to right

On 17 aug, 15:08, ekkeindoha < XXXX@XXXXX.COM >

>>>>>> Good day, >>>>>> Please help. I would like to get a formula for the following. >>>>>> The boxes can take the folling weight as maximum. >>>>>> (A) 50 (B) 45 gt;gt;gt;(C) 30

> > > If I give a total of 130 it should give me 2 X A>an> > > C.

>

> > > Thanks

Suppose a total value is in A1, A value is in B1, B value is in C1 and

C value is in D1.

Then:

in B3 enter formula =A1

in C3 enter formula =MOD(B3,B1)

in D3 enter formula =MOD(C3,C1)

Finally, to get an output :

in B2 enter formula =INT(B3/B1) and copy it to right

On 17 aug, 15:08, ekkeindoha < XXXX@XXXXX.COM >

>>>>>> Good day, >>>>>> Please help. I would like to get a formula for the following. >>>>>> The boxes can take the folling weight as maximum. >>>>>> (A) 50 (B) 45 gt;gt;gt;(C) 30

> > > If I give a total of 130 it should give me 2 X A>an> > > C.

>

> > > Thanks

Good day,

"Euro" thx it seems your short formula are excellent, but I'm still stuck

with a slight issue on this. If I do it like you say and enter the total

value as 60, it gives me

A B C D

60 68 58 28

0 1 0

60 60 2

(0.88) (1.03) (2.14)

As you will notice there are extra figures right at the bottom.The idea is

to explain what I would like to change.B=88% and C=103%. At the end of the

day it would be better for me to use B as there are only 12% open and with B

running 3% over, I must use another box because all must go and to loose 12%

are a better opton.

Sorry for all this issues.

Thx

"Euro" thx it seems your short formula are excellent, but I'm still stuck

with a slight issue on this. If I do it like you say and enter the total

value as 60, it gives me

A B C D

60 68 58 28

0 1 0

60 60 2

(0.88) (1.03) (2.14)

As you will notice there are extra figures right at the bottom.The idea is

to explain what I would like to change.B=88% and C=103%. At the end of the

day it would be better for me to use B as there are only 12% open and with B

running 3% over, I must use another box because all must go and to loose 12%

are a better opton.

Sorry for all this issues.

Thx

1. Best Fit Format for numbers

3. curve fitting + best fit modeling

4. what is the best way to resize test that "best fits" the text box

5. fit (round) a number to a special other number

6. GENERATE RANDOM NUMBERS TO FIT INTO RESULT OF PARTICULAR NUMBER

7. Passing array to a fit function which is being fitted with the function FIT

8. What does it mean to "Apply Best Fit" to an Access table?

9. Need help on printing best-fit based on original aspect ratio

10. How to get best fit on row height

11. Best fit lines

12. Scatterplot with a best-fit line

14. GDI+ FAQ: Problem with best-fit transform and JPEG image

15. How do I add a curve of best fit?

8 post • Page:**1** of **1**