Excel geeks probably don't know much about Cube vs Weight for trucking.
Perhaps you can give us more info? What is an example of a Cube value? Is
it a measure of the area inside of the truck? Perhaps give us sample data
for one with a weight and then one that is cubed?

"cjgrossley" wrote:

I am putting together a freight matrix to calculate the loadfactor on
truckloads. I have run into a problem with some of the product because it
cubes out the truck verses weighing out the truck. On the product that
weighs out, I am able to use the IF function to make sure I am shipping the
maximum weight allowed per truckload without being to heavy. On the product
that cubes out, I need a way to recognize that product in a formula by
converting the cube size to a number that will let me know that it is a cube
product issue and that is why the maximum truckload weight is not attained.

Please Help!