I would like to write an IF and statement either in a formula ora macro which will do the following:
If column A equals column D and column C is greater than 0 andcolumn B is greater than column E then return value A Or if columnC is equal to zero and column E is greater than column B returnvalue A
Basically, For my project, I have two files that share many ofthe same item codes. I want to make a list of the item codesthat are on order but the inventory did not increase
and I want to include the item codes that were not on order butthe inventory increased anyway.
1 2 3 4 5 6 7 8 9 10 A item code 1111 11112 11113 11115 B inventory 5 0 1 3 с on order 1202 D Item code 1111 11114 11113 11115 E iny after 4 0 2 8 F Result
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!