IF statement with multiple variables and results

**lance214** · 04-22-2012, 01:07 PM

Excuse me if I do not explain correctly but I will try to be as clear as I can. I am setting up a freight program for my shipping clerk. She is new to the position and I am trying to make the transition as easy as possible. Here is what I am trying to do.

1. She will enter the dimensions of each item being shipped into three separate columns
2. Result will appear in fourth
3. This result will be broken down into cubic inches.
4. The cubic inches number must be compared to the freight tariff codes. Example, if number is higher then 10 but less then 12 will result in a freight class. If lower then 10 but higher then 8 another class. And so on and so on.

The IF statement will hold at least 12 variables and I was not sure if that is possible nor the correct syntax to write the formula. We recently switched to Office 2007 so I am learning as I go. Was trying to make this formula in last column so she knew what class to use for each shipment. I have everything set expect the important, i.e. hard, part. Any help would be appreciated. Thank you.

**DGagnon** · 04-22-2012, 01:57 PM

with 12 variables you might be better off using a lookup instead of an if statement, there are a few ways to do it, the easiest would be to include a list to lookup against, and a bit cleaner you could include it all int he formula, but it might be harder to read.

**lance214** · 04-22-2012, 04:12 PM

Not sure how I would accomplish this. I could embed the chart showing the freight classes and their corresponding numbers but how would I use a formula that would lookup a number that was in a range? Or are you saying just embed the list for comparative purposes and drop the formula due to size? Not sure I am comprehending what you are telling me. Thank you for the reply