+ Reply to Thread
Results 1 to 2 of 2

IF Function when Price Above 700 and SSD is "Y" how to bring the text I need?

  1. #1
    Registered User
    Join Date
    08-18-2017
    Location
    Mexico
    MS-Off Ver
    Office 2016
    Posts
    40

    IF Function when Price Above 700 and SSD is "Y" how to bring the text I need?

    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
    Last edited by D2S; 10-16-2017 at 05:43 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: IF Function Continuation (a little bit more complex than previous thread)

    deleted......double post solved elsewhere
    Last edited by protonLeah; 10-17-2017 at 04:36 PM.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] in need of altering formula from previous thread
    By RachelMads02 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-25-2016, 05:31 PM
  2. [SOLVED] Ne Question Addition to previous thread
    By RachelMads02 in forum Excel General
    Replies: 10
    Last Post: 05-05-2016, 11:44 AM
  3. Question on a formula posted in a previous thread
    By FDibbins in forum Excel General
    Replies: 9
    Last Post: 03-11-2012, 05:36 PM
  4. Extra to previous thread by spitinyari
    By Roger_the_Dodger_55 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-14-2008, 06:35 PM
  5. Previous Thread/Next Thread
    By ChemistB in forum ExcelTip.com Feedback / Comments / Suggestions
    Replies: 0
    Last Post: 01-31-2008, 10:32 AM
  6. Still looking for assistance on previous thread...
    By kmham in forum Excel General
    Replies: 1
    Last Post: 02-18-2007, 07:33 AM

Bookmarks

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