W
westlawnman
I can't seem to write the formula for the following situation:
If inventory is less that 6 weeks, increase inventory 1 week per month until reaching 6 weeks, if inventory is more than 6 weeks but less than 30 weeks decrease inventory 1 week per month to hit 6 weeks, if inventory is greater than 30 weeks but less than 36 then decrease inventory 1.25 weeks per month to reach 6 weeks and if inventory is over 36 weeks decrease inventory proportionately as would occur over 24 months at a rate not less than 1.5 weeks per month to hit 6 weeks.
The first part to get to six weeks was easy but I can't figure the rest out. Can anyone help write a stsement that works????
(e-mail address removed)
If inventory is less that 6 weeks, increase inventory 1 week per month until reaching 6 weeks, if inventory is more than 6 weeks but less than 30 weeks decrease inventory 1 week per month to hit 6 weeks, if inventory is greater than 30 weeks but less than 36 then decrease inventory 1.25 weeks per month to reach 6 weeks and if inventory is over 36 weeks decrease inventory proportionately as would occur over 24 months at a rate not less than 1.5 weeks per month to hit 6 weeks.
The first part to get to six weeks was easy but I can't figure the rest out. Can anyone help write a stsement that works????
(e-mail address removed)