Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Formula giving different results
2 views
Skip to first unread message
RD
Apr 18, 2010, 8:54:01 AM4/18/10
to
I am trying to set up an inventory formula that looks at what is on order, on
hand, demand and a minimum qty. If "A" is on hand, "B" is on order, "C" is
demand &"D" is minimum qty. I would like to have "Trouble" returned if "C" is
greater than A&B, "Caution" returned if A+B is >C but < D, and "OK" returned
if A+B>C and >D. I have tried many variations but just cannot seem to get it
to work. I am using Excel 2003. Your help is really appreciated.
hand, demand and a minimum qty. If "A" is on hand, "B" is on order, "C" is
demand &"D" is minimum qty. I would like to have "Trouble" returned if "C" is
greater than A&B, "Caution" returned if A+B is >C but < D, and "OK" returned
if A+B>C and >D. I have tried many variations but just cannot seem to get it
to work. I am using Excel 2003. Your help is really appreciated.
0 new messages