+ Reply to Thread
Results 1 to 7 of 7

Multiple condition , need to resolve by if formula

  1. 04-04-2018, 12:34 PM #1
    nur2544
    nur2544 is offline
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Multiple condition , need to resolve by if formula

    Dear all,
    I have data sheet in the range A:E that cell filled with the date. after analysis all data, I want to get the results in the CELL F.
    below is the condition 

    Please Login or Register  to view this content.
    Please find the attached file , here I have shown the actual results.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-04-2018, 01:19 PM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Multiple condition , need to resolve by if formula

    this looks like it should work for you...
    =IF(AND(A2="",B2=""),"RO",IF(AND(A2<>"",B2=""),"ER",IF(AND(A2="",B2<>""),"ER",IF(AND(A2<>"",B2<>"",C2<>"",C2<E2,D2<>"",D2<E2),"RO",IF(AND(A2<>"",B2<>"",C2="",D2=""),"ER",IF(AND(A2<>"",B2<>"",C2<>"",D2=""),"ER",IF(AND(A2<>"",B2<>"",C2="",D2<>""),"ER","")))))))
    at least it matches your results.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  3. 04-04-2018, 01:30 PM #3
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Multiple condition , need to resolve by if formula

    this if you don't want "Ro" when all are blank...
    =IF(AND(A2="",B2="",C2="",D2="",E2=""),"",IF(AND(A2="",B2=""),"Ro",IF(AND(A2<>"",B2=""),"ER",IF(AND(A2="",B2<>""),"ER",IF(AND(A2<>"",B2<>"",C2<>"",C2<E2,D2<>"",D2<E2),"Ro",IF(AND(A2<>"",B2<>"",C2="",D2=""),"ER",IF(AND(A2<>"",B2<>"",C2<>"",D2=""),"ER",IF(AND(A2<>"",B2<>"",C2="",D2<>""),"ER"))))))))
    Reply With QuoteRegister To Reply
  4. 04-04-2018, 01:45 PM #4
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,197

    Re: Multiple condition , need to resolve by if formula

    Try

    =IF(OR(AND(A2="",B2=""),OR(AND(C2<>"",C2<E2,D2<>"",D2<E2))),"RO","ER")

    matches your results
    Reply With QuoteRegister To Reply
  5. 04-04-2018, 01:48 PM #5
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Multiple condition , need to resolve by if formula

    I like when people see the patterns I miss to give shorter formulas, nice job John!
    Reply With QuoteRegister To Reply
  6. 04-04-2018, 09:38 PM #6
    nur2544
    nur2544 is offline
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: Multiple condition , need to resolve by if formula

    Quote Originally Posted by Sambo kid View Post
    this looks like it should work for you...
    =IF(AND(A2="",B2=""),"RO",IF(AND(A2<>"",B2=""),"ER",IF(AND(A2="",B2<>""),"ER",IF(AND(A2<>"",B2<>"",C2<>"",C2<E2,D2<>"",D2<E2),"RO",IF(AND(A2<>"",B2<>"",C2="",D2=""),"ER",IF(AND(A2<>"",B2<>"",C2<>"",D2=""),"ER",IF(AND(A2<>"",B2<>"",C2="",D2<>""),"ER","")))))))
    at least it matches your results.
    Hi Sam C , Thanks for helping me , I have tried to implement both of your formula , here both are working except one logic (If CELL C & D have date but less than CELL E then CELL F will be "RO") if it is less than then it works as well but if it Greater than then it is not working. I appreciated your nice job.
    Last edited by nur2544; 04-04-2018 at 09:57 PM.
    Reply With QuoteRegister To Reply
  7. 04-04-2018, 09:48 PM #7
    nur2544
    nur2544 is offline
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: Multiple condition , need to resolve by if formula

    Quote Originally Posted by JohnTopley View Post
    Try

    =IF(OR(AND(A2="",B2=""),OR(AND(C2<>"",C2<E2,D2<>"",D2<E2))),"RO","ER")

    matches your results
    Hi JohnTopley , Yes it works great ! your shorter formula is nice , you are awesome , I appreciated it , many thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to resolve CONCATENATE formula function?
    By milvol in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-05-2021, 02:33 AM
  2. [SOLVED] How to resolve array formula in VBA
    By jprealini in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-24-2014, 10:27 AM
  3. Download, Resolve and Chart Multiple Date Series
    By JohnYard in forum Excel General
    Replies: 0
    Last Post: 02-06-2014, 11:56 AM
  4. [SOLVED] Resolve three logical conditions using an if formula...
    By sland01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2013, 04:48 PM
  5. How to resolve multiple VBA calculation events to just one worksheet
    By batman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-19-2009, 10:21 AM
  6. Resolve a problem with a sumproduct formula
    By dc123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-14-2008, 11:55 AM
  7. [SOLVED] resolve:formula problem
    By Andrew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2005, 07: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1