# Bring "Premium" when Price is Above \$700 and SSD "Y", also when Brand is "Apple" and...

1. ## Bring "Premium" when Price is Above \$700 and SSD "Y", also when Brand is "Apple" and...

Creating new thread from the old one to comply with protonLeah's request:

---

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
Attached Files Attached Files

2. ## Re: Bring "Premium" when Price is Above \$700 and SSD "Y", also when Brand is "Apple" and..

This seems to work:

=IF(Table2[@[Gaming Y/N]]="Gaming","Not ", IF(OR(Table2[@[SSD Y/N]]="N",AND(Table2[@[SSD Y/N]]="Y",Table2[@Column1]<700)), "Not ", "")) &"Premium"

3. ## Re: Bring "Premium" when Price is Above \$700 and SSD "Y", also when Brand is "Apple" and..

Hi JBeaucaire,

It works in the example I attached, however, I need to include also the restriction of the word "Apple", because when I apply it in my Database it will not bring me the desired result, what I want to say in the formula is:

If column "Gaming Y/N" (Col E) has the text "Gaming", bring "Not Premium", but if the USD price per unit is Above \$700 (Col C) and has an SSD "Y" (Col F) (both of these being one rule), and my Brand is Apple (Col D), bring me "Premium", if not bring "Not Premium".

Let me know if the above explanation works.

Thanks,
D2s

4. ## Re: Bring "Premium" when Price is Above \$700 and SSD "Y", also when Brand is "Apple" and..

.
Perhaps this in G2 and drag down :

``Please Login or Register  to view this content.``

5. ## Re: Bring "Premium" when Price is Above \$700 and SSD "Y", also when Brand is "Apple" and..

So this then?:

=IF(Table2[@[Gaming Y/N]]="Gaming","Not ", IF(OR(Table2[@[SSD Y/N]]="N",AND(Table2[@[SSD Y/N]]="Y",Table2[@Column1]<700,Table2[@[Brand Cluster]]<>"Apple")), "Not ", "")) &"Premium"

6. ## Re: Bring "Premium" when Price is Above \$700 and SSD "Y", also when Brand is "Apple" and..

Hi Logit,

Thanks for your reply, I tried the formula but I will only get a result for lines 4 to 6, the rest of the lines there is a blank.

I want to apply the following rules to bring "Premium"
-1st rule: If SSD = "Y" and USD is above \$700 (this in one segment)
-2nd rule: If Brand Cluster = "Apple"

-3rd rule: If Gaming Y/N = "Y"

So this would mean the following:
All Apple units are Premium, but is one is classified as Gaming Y/N = "Y", will return "Non Premium"
If my combination of above 700 & SSD is "Y", classify at "Premium" (this would mean that all brands that fall into this category will be "Premium" but also if Gaming is "Y", I will output "Non Premium")

7. ## Re: Bring "Premium" when Price is Above \$700 and SSD "Y", also when Brand is "Apple" and..

Hi Beau,

Still got the issue, I'll be looking on my side meanwhile as well.

D2S

8. ## Re: Bring "Premium" when Price is Above \$700 and SSD "Y", also when Brand is "Apple" and..

I got it the answer is:

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1