Ok, it's as I suspected and I misunderstood at first. I was thinking you had six tables, but you have ten, two for each door.
Now, your workbook has to determine which of the ten tables to use. One choice is easy; the user must somehow indicate whether his figures are in inches or centimeters. But the other I'm not sure of. He must give two figures, I gather, and indicate whether they are height, width or length; and your logic must take those two figures, figure out which door(s) they'll fit through, and then figure out the maximum quantity of the missing dimension that will fit through one of those doors. For example: The user has a package that is 1800cm high and 3000cm long. Three of the doors won't take that package at all; but there is one door that can take it if it's no wider than 400 cm, and another than can take it even if it's as much as 1100 cm. So the user enters "cm", 1800, "height", "3000" and "length", and the worksheet gives 1100 as the answer. Like that?
But if so, I'm having trouble picturing how it is that you can have just one table for each door (or rather two, depending on in/cm). Could you let me have a look at the tables for two of the doors, just so I can see how this works?
|