+ Reply to Thread
Results 1 to 2 of 2

Formula to look at range of text and IF statement if values contained in differing range

  1. #1
    Registered User
    Join Date
    11-07-2014
    Location
    Durham, NC
    MS-Off Ver
    Excel: Mac 2011
    Posts
    2

    Formula to look at range of text and IF statement if values contained in differing range

    I have a large table of data. In one column is a name of an opportunity, in the 2nd column is the product that is a part of that opportunity, and in the 3rd is the price. I am trying to write a formula in the 4th column (Actual Price) that basically says the following...

    IF Opportunity A has Product C and either Product A or Product B, then Actual Price for Product C is 0, otherwise it is = to Price in Column C.

    The Opportunities can not be sorted alphabetically. I have attached the below table in Excel for added help.

    A B C D
    1 Opportunity Product Price Actual Price
    2 Opportunity A Product A 100 100
    3 Opportunity A Product B 200 200
    4 Opportunity A Product C 300 0
    5 Opportunity B Product A 100 100
    6 Opportunity B Product B 200 200
    7 Opportunity B Product D 400 400
    8 Opportunity C Product A 100 100
    9 Opportunity C Product B 200 200
    10 Opportunity B Product C 300 0
    11 Opportunity A Product E 500 500
    12 Opportunity C Product D 400 400
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Formula to look at range of text and IF statement if values contained in differing ran

    for d2 it woud be:

    Please Login or Register  to view this content.

+ 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] If cell contains text contained in a named range return the row number
    By spoursy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-05-2014, 05:54 AM
  2. Getting chart range from range address contained in a cell
    By Journeyman3000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-03-2013, 08:10 PM
  3. [SOLVED] Return specific text if a different text is contained anywhere in a range of cells
    By ciayers in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2013, 05:54 PM
  4. [SOLVED] How to increment values contained in a Variant and to put in a Range
    By JohnM3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2012, 10:10 AM
  5. Getting a range from an array formula contained in a cell
    By kayard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2007, 04:08 PM

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