This has to do with my purchased items reorder sheet where I have a column
that is populated with the required amount of purchased items needed to build
the amount of trailers from the schedule. Another column has the vendors
required minimum that we have to order so as to keep a certain price level.
Then I have the columns for my inventory levels and quantities of outstanding
purchase orders. My dilemma is in my €œRe Order€� column where I'm subtracting
my inventory and outstanding quantities from the required pcs needed in which
trying to also set it up so it takes into account the minimum required by the
vendor so it will only populate when it gets equal to or above the minimum
required quantities