+ Reply to Thread
Results 1 to 6 of 6

How to compare 2 different value as true and another 2 different value as true or false

  1. 05-10-2016, 10:38 PM #1
    lia86
    lia86 is offline
    Registered User
    Join Date
    05-10-2016
    Location
    malaysia
    MS-Off Ver
    2013
    Posts
    14

    How to compare 2 different value as true and another 2 different value as true or false

    Hi All,

    I have 2 columns as below.
    1.jpg

    how do i create all below comparison in one formula:
    EP = FW -> TRUE
    FW = EP ->TRUE

    and for below, return FALSE if the value are not the same.
    PR3 = PR3 ->TRUE
    PR1 = PR1 -> TRUE
    PR2 = PR2 -> TRUE
    LOCAL = LOCAL -> TRUE

    thanks.
    Attached Images Attached Images
    Last edited by lia86; 05-10-2016 at 11:57 PM.
    Reply With QuoteRegister To Reply
  2. 05-10-2016, 11:08 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: How to compare 2 different value as true and another 2 different value as true or fals

    So maybe...
    =or(A1=B1,and(A1="FW",B1=EP")and(A1="EP",B1="FW))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 05-10-2016, 11:23 PM #3
    lia86
    lia86 is offline
    Registered User
    Join Date
    05-10-2016
    Location
    malaysia
    MS-Off Ver
    2013
    Posts
    14

    Re: How to compare 2 different value as true and another 2 different value as true or fals

    i have tried the formula but when EP=FW still return FALSE

    2.JPG

    kindly advise.

    thanks
    Reply With QuoteRegister To Reply
  4. 05-10-2016, 11:44 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: How to compare 2 different value as true and another 2 different value as true or fals

    Apologies, there was a typo...
    A
    B
    C
    1
    		 FW FW
    TRUE
    2
    		 PR3 PR3
    TRUE
    3
    		 EP FW
    TRUE
    4
    		 PR3 PR1
    FALSE
    5
    		 FW FW
    TRUE

    C1=OR(A1=B1,AND(A1="FW",B1="EP"),AND(A1="EP",B1="FW"))
    copuied down
    Reply With QuoteRegister To Reply
  5. 05-10-2016, 11:57 PM #5
    lia86
    lia86 is offline
    Registered User
    Join Date
    05-10-2016
    Location
    malaysia
    MS-Off Ver
    2013
    Posts
    14

    Re: How to compare 2 different value as true and another 2 different value as true or fals

    it works! thanks for your help!
    Reply With QuoteRegister To Reply
  6. 05-11-2016, 12:09 AM #6
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: How to compare 2 different value as true and another 2 different value as true or fals

    Happy to help
    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. Compare dates and return true or false
    By Burt_100 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-22-2014, 04:00 PM
  2. What is best to use for helper cells 0 or 1, typed true or false or =true =false
    By Gingermuppet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:41 PM
  3. [SOLVED] in this TRUE OR FALSE function, i want desired name instead of display true or false
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 06:44 PM
  4. Compare two excel files and display true or false
    By sravanthi009 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-01-2011, 11:36 AM
  5. Search for 2 true arguments and return true or false
    By David in forum Excel General
    Replies: 3
    Last Post: 07-15-2006, 05:20 AM
  6. [SOLVED] Function to return True/False if all are validated as True by ISNU
    By Tetsuya Oguma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2006, 06:30 AM
  7. [SOLVED] Reverse false and combine with true true value
    By Emmie99 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1