I have uploaded a sample of what I am trying to accomplish.
1) if A (the quantity used to make this product) its greater than C (the inventory we have on file) AND B (the name of the product being looked up is present. Sometimes it will be blank) AND D is YES have it respond with a 0 in E.
2) if A (the quantity used to make this product) its greater than C (the inventory we have on file) AND B (the name of the product being looked up is present. Sometimes it will be blank) AND D is NO have it respond with a 1 in E.
3) if A (the quantity used to make this product) its less than C (the inventory we have on file) AND B (the name of the product being looked up is present. Sometimes it will be blank) have it respond with a 1 in E.
4) if B="" respond with a 0 in E.
If you are wondering why I am using "0" as a positive result it is because there are many more parts used to make the sets so there might be 5 or 10 or 20 of these Flag checks. Ultimately then I will do a =sum of all of the flags and if that SUM is not 0, it means the set can not be made.
Thanks for your help with this.
Bookmarks