+ Reply to Thread
Results 1 to 3 of 3

Formula with multiple if conditions

  1. #1
    Registered User
    Join Date
    04-24-2014
    Location
    Willowbrook, USA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Formula with multiple if conditions

    Hello,

    I have a table of information. I am trying to write a formula that compares the values in the columns of the table, and it need to place an 'x' if it meets the below condition. Attached an excel file with this information.

    Any ideas on how I make this work? Appreciate your help!

    Condition: if project id, production column cell values are same, keep 'x' in one cell corresponding to the highest 'HP' value in summary column, If 'HP' value is same in more than one cell, keep 'x' in any one cell. If project id and production column cell values are different, keep 'x' in summary column for each different row.

    Thanks,

    pm.
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Formula with multiple if conditions

    Try in F2:

    Please Login or Register  to view this content.
    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
    Quang PT

  3. #3
    Registered User
    Join Date
    04-24-2014
    Location
    Willowbrook, USA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Formula with multiple if conditions

    It worked. Thanks a lot!

+ 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. 3 multiple conditions with multiple criteria formula help
    By rmnk101190 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-29-2013, 04:37 PM
  2. [SOLVED] Syntax for formula that uses multiple conditions inside of multiple IF statements
    By njmiller31 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2013, 11:55 AM
  3. Formula with multiple conditions
    By Dr M in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-25-2011, 12:33 PM
  4. [SOLVED] MULTIPLE CONDITIONS FORMULA
    By TLAngelo in forum Excel General
    Replies: 3
    Last Post: 05-01-2006, 08:55 PM
  5. [SOLVED] multiple conditions formula
    By Tom Ogilvy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 06:05 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