+ Reply to Thread
Results 1 to 4 of 4

If Then Else Stament When Condition Met

  1. #1
    Registered User
    Join Date
    09-07-2018
    Location
    Indianapolis
    MS-Off Ver
    MS 2016
    Posts
    7

    If Then Else Stament When Condition Met

    Hello;
    I am working on a status report and looking to populate date if only applicable to certain condition. For example, If a project is within a the 5 day SLA then it would populate in the 5 day SLA cell (H4) if its a 10 day SLA them # populates in (J4) cell. The condition can reference the (G4) cell.

    5 or 10 Day SLA Cells.jpg

    It would also be useful if the field would populate "N/A" for cells (I4) and (K4) to let the user know that corresponding SLA timeline is NOT applicable.

    Much appreciated
    Michael

    File is attached too! thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: If Then Else Stament When Condition Met

    Enter this in cell H4 and fill down. While that range is still selected copy it and paste into J4.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  3. #3
    Registered User
    Join Date
    09-07-2018
    Location
    Indianapolis
    MS-Off Ver
    MS 2016
    Posts
    7

    Re: If Then Else Stament When Condition Met

    This worked perfectly! thanks so much...

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: If Then Else Stament When Condition Met

    You are welcome. Thank you for the feedback.

+ 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] Rotate List of names bottom to top Repeat without condition with option to set a condition
    By spyac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-05-2018, 05:17 PM
  2. having problem trying to get a if stament to work cant seam to get my head round it.
    By dawilson89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2015, 12:50 PM
  3. 3 Nested IF stament
    By Disney4me in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-18-2014, 09:37 AM
  4. MAKE CELL BLANK IF VALUE = 0 (any ideas on adding an if stament to VBA code)
    By eaykan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2013, 12:59 PM
  5. No change cell value if the IF stament is FALSE.
    By flakis05 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-23-2012, 10:52 AM
  6. multi condition format? lookup and date condition valid for.
    By D_Rennie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-13-2009, 11:37 AM
  7. IF Stament formula nesting
    By batmanlasd in forum Excel General
    Replies: 2
    Last Post: 10-27-2005, 04:05 PM

Tags for this Thread

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