Hi everyone,
Apologies in advance if this is a silly question, but i cant seem to get this IF statement to work.
Example:
Qty Type Variant Filter
10 Apple A
15 Orange A
31 Apple B
20 Orange B
20 Apple A
40 Orange C
I'm trying to create an IFStatment formula to auto populate the filter column with the word 'Sell':
return 'SELL' if Type is Apple and Variant is A with QTY greater than 15 only and return 'RESERVE' is QTY is less than 15?
Is this possible to generate into a IFstatment/ formula please?
Thanks in advance everyone
CT
Bookmarks