Hi all
I can't get a formula to work today can someone help please?
I have fruits and packaging options, and there are some new packaging options which are not available for all the fruits yet.
Raspberries and Strawberries can't be in baskets and crates yet, so I have a column in which I would like to write a formula, that spells "Mistake" if for Raspberries or Strawberries the listed packaging option is basket or crate, returns nothing if the packaging option is anything else.
Something like:
=IF(AND(OR(A2<>"Basket",A2<>"Crate"),OR(B2="Raspberry",B2="Strawberry")),"Mistake","")
But this formula returns "Mistake" even if the packaging option is something else not Basket or Crate.. Not sure what I did wrong.
It has to return "Mistake" only if:
Raspberry - Basket
Raspberry - Crate
Strawberry - Basket
Strawberry - Crate
are in A and B columns.
If its anything else:
Raspberry - Box
Mango - Crate
It should return nothing ("")
Please help!
Bookmarks