Hi,
Trying to align this new data I came to a different question:
In column F I want to output either the word "Premium", or "Not Premium" with the following rules:
Output "Pure Premium" in column F when:
-SSD "Y" and USD/Units =>700 (the combination of these two together)
-Brand Cluster is "Apple"
In the same formula, output "Not Premium" when:
Column D (Gaming Y/N) is "Gaming"
Sorry to ask all these question, just that logic/math is not my forte, thank you for your help.
Attaching a new workbook as an example with more clear information.
Also as a reference I was using this formula before: =IF(AND([@[Gaming Y/N]]="Gaming",OR([@USD]/[@Units]>=700,[@[Brand Cluster]]="Apple",[@[SSD Y/N]]="Y")),"Not Premium",IF(OR([@USD]/[@Units]>=700,[@[Brand Cluster]]="Apple",[@[SSD Y/N]]="Y"),"Premium","Not Premium")) <--- however in this logic, I'm not combining the restriction of SSD "Y" and USD/Units all together as one restriction where I want to have all this as one rule.
D2S
Bookmarks