Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Determine sums based on value possibilities
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
formula to determine the first column containing any data | Excel Worksheet Functions | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Modify Row based upon cell value | Excel Worksheet Functions | |||
count based on two fields - need quickly | Excel Worksheet Functions |