+ Reply to Thread
Results 1 to 7 of 7

Help Creating Nested IF/OR or OR/IF Formula with Outcomes Based on Several Conditions

  1. #1
    Registered User
    Join Date
    02-17-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    14

    Help Creating Nested IF/OR or OR/IF Formula with Outcomes Based on Several Conditions

    I have an "IF" formula whereby if one cell is empty - let's say it is Cell H8, the value in the target cell (F8) is empty, and if H8 has any value, the value in target cell F8 is the date in a different cell, C2. Alone, that formula works flawlessly.

    However, I want to run instead a nested IF/OR (or would it be an OR/IF) formula so that if H8 has any value, and another cell, E8, has for example a value of "1", the date in my target cell F8, will not be the date in C2, but a date of "01/01/2014", (thus the "1"). Same with 2 (=02/01/2014), 3 (=03/01/2014), etc.

    I cannot seem to come up with the right formula. Excel keeps trying to fix it by inserting a multiplication operand of "*" between the IF logical test and value and the OR logical test and values. And when it appears the formula is right the yield in my target cell just shows "TRUE".

    Can someone help? Most grateful, thanks!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,422

    Re: Help Creating Nested IF/OR or OR/IF Formula with Outcomes Based on Several Conditions

    Maybe:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    formatted as a Date.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,022

    Re: Help Creating Nested IF/OR or OR/IF Formula with Outcomes Based on Several Conditions

    Something like this (formatted as a date)??
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Help Creating Nested IF/OR or OR/IF Formula with Outcomes Based on Several Conditions

    in F8
    =IF(AND(H8<>"",E8<>""),DATEVALUE(H8&"/01/2014"),IF(H8<>"",C2,""))
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  5. #5
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Help Creating Nested IF/OR or OR/IF Formula with Outcomes Based on Several Conditions

    aren't those US dates ? =03/01/2014) being march 1?
    =IF(H8="","",IF(AND(E8>=1,E8<=12),DATE(2014,E8,1),"not valid"))
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,022

    Re: Help Creating Nested IF/OR or OR/IF Formula with Outcomes Based on Several Conditions

    Good point. I hadn't noticed that OP was in the States. If so, go with the solution immediately above, using the DATE function.

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,422

    Re: Help Creating Nested IF/OR or OR/IF Formula with Outcomes Based on Several Conditions

    Ditto. Well picked up Martin. I did wonder about the possibilities, for example, February ... so US Dates makes it easier.

    Cheers, TMS

+ 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] Need help in creating a COUNTIF formula based on 2 conditions
    By Manish_Gupta in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2014, 11:53 AM
  2. [SOLVED] IF formula for mulitple conditions and multiple outcomes
    By kazthomas in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-06-2012, 08:31 PM
  3. Creating A Formula Based On Multiple Outcomes
    By artiststevens in forum Excel General
    Replies: 8
    Last Post: 01-20-2012, 12:27 AM
  4. Nested IF statement 3 conditions 3 outcomes
    By Nick_in_Dubai in forum Excel General
    Replies: 1
    Last Post: 03-12-2009, 04:38 AM
  5. nested if with three outcomes
    By inky in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2008, 05:38 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