I have 20,000 items on spreedsheet.
I need to find products that are over/heavy stocked.
Columns are
Product / Package size/ amount on hand / Max usage a day.
Broom / 12 / 53 / 22
pan / 400 / 150 / 65
spoon / 1.5 / 2 / 1
etc.
I tried several if functions but they are not taking in all considerations.
the problem is some items have to be ordered in a certain size.
ex. 1.5 paks and have 2 on hand, my formula says were heavy on stock when its not.
I need a formula that will look at amount on hand, compared to package size , and max use a day. then return if product is heavy on stock.
Company likes stores to have no more than max usage a day on hand.
I was doing if formula on just single product and returning ok, or heavy.
but it isn't always being correct.
any ideals? on a formula, or example!
thanks
I need to find products that are over/heavy stocked.
Columns are
Product / Package size/ amount on hand / Max usage a day.
Broom / 12 / 53 / 22
pan / 400 / 150 / 65
spoon / 1.5 / 2 / 1
etc.
I tried several if functions but they are not taking in all considerations.
the problem is some items have to be ordered in a certain size.
ex. 1.5 paks and have 2 on hand, my formula says were heavy on stock when its not.
I need a formula that will look at amount on hand, compared to package size , and max use a day. then return if product is heavy on stock.
Company likes stores to have no more than max usage a day on hand.
I was doing if formula on just single product and returning ok, or heavy.
but it isn't always being correct.
any ideals? on a formula, or example!
thanks