+ Reply to Thread
Results 1 to 10 of 10

Parenthesis with complex if statements

Hybrid View

  1. #1
    Registered User
    Join Date
    02-19-2022
    Location
    usa
    MS-Off Ver
    2016
    Posts
    4

    Re: Parenthesis with complex if statements

    Thanks Ali!

    But let me clarify what I was trying to get in one cell.

    The way I labeled the columns in my example is confusing.

    Instead of "Latest Absent DA" or "Latest Communication DA" (so on so forth) I should have written "Latest Absent DA LEVEL" and "Latest Communication DA LEVEL", etc, thus the need for the INDEX(Match.

    I don't want to return the date, I want to return the Level associated with the date.

    So I want something that is Indexing the Level (Verbal, Final, or Written?) and matching it to the employee name, the disciplinary type ("absent" "communication" or "tardy") and the latest date that this DA was received based on the type of DA indicated in the column

    So like for the "Absent Column I think it would be something like:

    INDEX(THE LEVEL COLUMN on the disciplinary action sheet,MATCH(1(EMPLOYEE NAME on disciplinary action sheet=NAME IN 1ST CELL IM REFERENCING) * (DISCIPLINARY ACTION COLUMN on the disciplinary action sheet="Absent") * (MAX(IF(NAMES IN COLUMN A on the disciplinary action sheet=NAME IN FIRST CELL IM REFERENCING,IF(DISCIPLINARY ACTION LEVEL COLUMN on the disciplinary action sheet="Absent", DATES LISTED IN COLUMN on the disciplinary action sheet),0))

    But I cannot get this formula to work when I try to incorporate MAX(IF(IF into the index(match with multiple criteria.

    It's starting to look like a science project.
    Last edited by ihateexcel17; 02-20-2022 at 03:41 PM.

+ 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] Complex If/Then Statements
    By CorvusReed in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-03-2014, 06:36 PM
  2. Replies: 1
    Last Post: 03-30-2012, 01:42 PM
  3. Excel 2007 : Complex IF Statements
    By JonathanKilleen in forum Excel General
    Replies: 1
    Last Post: 11-27-2009, 06:03 AM
  4. Excel 2007 : Complex IF Statements.
    By JonathanKilleen in forum Excel General
    Replies: 1
    Last Post: 11-27-2009, 05:29 AM
  5. complex SUMPRODUCT statements
    By cvillemtnman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-23-2008, 06:18 PM
  6. Complex Vlookup and List Validation and Nested IF statements
    By Bobby in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-09-2006, 01:40 PM
  7. complex if statements in excel
    By Julieeeee in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-26-2005, 05:06 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