Sorry it has taken me a couple days to respond. I work in the restaurant business and the hours are significant.
I manually ran a few values through my E7 formula and the results come out as desired. So, I'm not sure why you wrote that the formula looks odd. As you saw, the formula consists of two basic parts. The first tests if D7 is > 1. If it is, it rounds D7 minus .09, up to a whole number. The second part is only executed when D7 is equal to or less than 1. Hence, a D7 value of > .09 and is rounded to 1 and all else yields a result of 0.
The problem I am trying to figure out is why does the sum of column E yield a number higher than the displayed values in column E? It's acting like the actual values stored in the E cells displays whole numbers, but when summed up, they carry the decimal components, yielding a larger product. Ugh!
Since my goal is to know how much to order of each item and to have an accurate total count of total cases to order, I went ahead and substituted your formula in place of mine for each item. To my disappointment, the total cases to be ordered by the column, summed to the same number as mine and this number is higher than it should be when compared to adding up manually the displayed number of cases to order. Ugh again! This leads me to believe that my original suspecian is true, the displayed item numbers are not what is summed for the column. Meaning, if the formulas indicate I'm to order 2 cases of an item because the displayed number of cases to order is 2, there is actually something other than 2 being summed for in the column as the column sum result is higher than the sum of the displayed item numbers.
I've also played with formatting the cells in column E as number with and without decimal places as well as I tried formatting the cells as general. I was hopeful to see decimal values when the cells were formatted as number with 2 decimal places, but to my disappointment, the cells only displayed .00 value. This of course burst my theory.
Any other suggestions folks?