Are you just looking to avoid the #DIV/0! error and negative values? Then do
something like this: =IF(OR(ISERROR([your calculation]),[your
calculation]<0),"",[your calculation])

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"DHallgren" wrote:

Hi! I am working on a spreadsheet which will show the 10 items with the most
inventory at each account, measured by weeks on hand. Weeks on hand is
calculated by dividing the value of inventory on hand by the averages sales
for the past several weeks (usually 13).

This is fairly straightforward unless an item has had no sales, or negative
sales (due to seasonality). Obvioulsy the formula will return #DIV/0! or a
negative number. Can someone help me with a formula that will return a value
that will return a value that can be sorted in descending order for
distribution to my coworkers, and easy population into presentations?

Thanks for any help you can give.
--
Diane