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.
Suppose a total value is in A1, A value is in B1, B value is in C1 and
C value is in D1.
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
"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.