Basicly I have 4 columns: first with stock in store A, second with mean consumption on store A, third with stock in store B and fourth with mean consumption on store B.
The aim is to have on the fith column and advise like: "Buy more", "Tranfer from store A to store B"; "Transfer from store B to store A"; "Do nothing".
I was trying to make if fuctions IF / OR / AND... but I'm a little lost.
Can someone help?
Thank you in advance
Bookmarks