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