+ Reply to Thread
Results 1 to 2 of 2

IF conditions

  1. #1
    Registered User
    Join Date
    11-04-2013
    Location
    Manchester
    MS-Off Ver
    Excel 2010
    Posts
    26

    Talking IF conditions

    Hi all,

    Seek the help from excel guru urgently.

    In the attached spreadsheet, I use it to track if deadline is over due or not.

    Column 1 will be today's date and column D3, F3,G3, H3 and I3 will be my parameters.

    Scenario as per below:

    1). If A/C Strategy (D3) = "Exit" or "Retain", then Status (H3) = blank and "Date of 1st reminder" (G3) will be 10 business days after "Date of Form sent to Biz" (F3) and "Next Deadline" (I3) = 10 business days after F3.

    2). If A/C Strategy (D3) = "Pending", then Status (H3) = "Pending" if today's date is smaller than
    "Date of Form sent to Biz" (F3), and "Date of 1st reminder" (G3) will be 10 business days after "Date of Form sent to Biz" (F3) and "Next Deadline" (I3) = 10 business days after F3.
    nd if Date of Form sent to Biz" (F3) > 30 business day, "Report to manager"

    3). If A/C Strategy (D3) = "Pending", then Status (H3) = "Follow up " if today's date is bigger than
    "Date of Form sent to Biz" (F3), and "Date of 1st reminder" (G3) will be 10 business days after "Date of Form sent to Biz" (F3) and "Next Deadline" (I3) = 10 business days after F3.
    and if Date of Form sent to Biz" (F3) > 30 business day, "Report to manager"


    Please assist with the query.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-16-2016
    Location
    Greece
    MS-Off Ver
    2013
    Posts
    69

    Re: IF conditions

    First of all, what is Column 1? Column A says "FIU Analyst"'. Also what is the actual question? It looks like everything works as you want it in the worksheet. I don't see why you can't nest more IFs to do what you want (or use a lookup table in another sheet). Can you be a bit more specific?

+ 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] Advanced Filter Between Two Columns all OR conditions (4 conditions)
    By nobodyukno in forum Excel General
    Replies: 2
    Last Post: 02-16-2017, 01:13 PM
  2. Replies: 2
    Last Post: 01-14-2016, 03:53 PM
  3. Replies: 6
    Last Post: 04-30-2015, 09:10 AM
  4. [SOLVED] Vlookup - Country conditions (Multiple conditions)
    By dluhut in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-26-2013, 11:42 AM
  5. [SOLVED] Text results with two conditions (lookup with two conditions)
    By Davzx in forum Excel General
    Replies: 8
    Last Post: 05-25-2012, 03:08 AM
  6. convert the if conditions to OR conditions
    By nynamyna in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-09-2011, 06:41 PM
  7. [SOLVED] How to multiple conditions to validate more than 2 conditions to .
    By Bhuvana Govind in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2005, 04: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