Jerry,
I can reasonably assume if the weight is greater
than 79lbs, it has 22, less than 79, 20. Based on this I
can identify fairly accurately if they have 20 or 22 units.
I based my 8 possiblities from the chart below:
A B C
75 75 75 Conversion of 2 cells needed
75 75 84 Conversion of 1 cell needed
75 84 84 No conversion needed
75 84 75 Conversion of 1 cells needed
84 75 75 Conversion of 1 cells needed
84 84 75 No conversion needed
84 75 84 No conversion needed
84 84 84 Conversion of 1 cells needed
I can LOOK at a row and immediately tell what needs to be
done, but I can't get a formula to easily do it.
Mike
-----Original Message-----
Since the weight of a bundle is not exactly predictable
("weights
fluctuate slightly by 1-2 pounds") you have far more than
8 combinations
if you are putting weights in the cells.
A straightford would be to use a single IF statement in
each of 3 other
cells to decide whether the corresponding weight cells
refer to 20 or 22
unit bundles. Then simply sum the total number of units.
Jerry
Mike K wrote:
Ok heres the easiest way to explain this.
I have bundles with either 20 or 22 units in them.
They come off an assembly line 6 units of 22, then 3
units
of 20, then they repeat. It is sold to the custumer in
64
unit increments (2 of 22 and 1 of 20) so we measure the
weights by the 64 unit measurements. They weights
fluctuate slightly by 1-2 pounds. How can I determine
by
placing 3 blind values in consecutive cells of a row,
when
to convert and when not to convert automatically. I
believe I have 8 possible combinations so I can't use
IF
statements. Should I use a table with the CHOOSE
statement? use LOOKUP? (which I can handle) or is there
an
easier way? Suppose I have 3 weights of 75.2lbs,75.4lbs
and 84.3lbs. I need to convert one of the smaller
weights
to a 22 unit equivilent then add them all together. If
all
three were high, one would need down converted. Ideally
an
operator could plug them in consective cells and the
formula would figure out how to up/down/leave alone the
correct values to achieve 2 large and one small. I
didn't
mean to go this long but I wanted to be clear.
Thanks,
Mike
.
|