+ Reply to Thread
Results 1 to 4 of 4

multiple condition requirement with multiple possible results

  1. #1
    Registered User
    Join Date
    06-23-2022
    Location
    Montreal
    MS-Off Ver
    365
    Posts
    2

    Question multiple condition requirement with multiple possible results

    Hi,

    i have a file where there are transactions that needs to be categorized with 4 possible outcome but needs to meet some conditions


    1)
    If col A contains: Deposits Credits AND contains in col B: Tfr Transfer Credit

    Result categorize the item as = HOC IN

    2)
    If Col A contains: Withdrawals Debits Other AND in col B: Tfr Transfer Debit

    Result categorize the item as = HOC OUT

    3)

    If col A contains: Deposits Credits AND DOES NOT CONTAIN in col B: Tfr Transfer Credit

    Result categorize the item as = WIRES IN


    4)

    If Col A contains: Withdrawals Debits Other AND DOES NOT INCLUDE in col B: Tfr Transfer Debit

    Result categorize the item as = WIRES OUT


    I have attached a data for ease of work.

    thanks
    Kam
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,835

    Re: multiple condition requirement with multiple possible results

    In D3, try:

    =IFS(AND(A3="Deposits Credits",B3="Tfr Transfer Credit"),"HOC IN",A3="Deposits Credits","WIRES IN",AND(A3="Withdrawals Debits Other",B3="Tfr Transfer Debit"),"HOC OUT",A3="Withdrawals Debits Other","WIRES OUT")

    And copy down.

    You use the word "Contains", but do you actually mean EQUALS. If truly "Contains", then put an asterisk before and after the text in column B (i.e., ...B3="*Tfr Transfer Credit*"...

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,779

    Re: multiple condition requirement with multiple possible results

    Please Login or Register  to view this content.
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    06-23-2022
    Location
    Montreal
    MS-Off Ver
    365
    Posts
    2

    Re: multiple condition requirement with multiple possible results

    Thank you so much, correct, i meant equal but good to know about the asterisk trick.

    it worked perfectly!!! thank you greatly

+ 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] Multiple IF & AND Condition Requirement
    By perpectuals in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-19-2021, 11:11 AM
  2. Multiple if statements to satisfy the requirement
    By imaliuddin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-02-2019, 02:53 PM
  3. [SOLVED] If Condition with Multiple Search & Multiple Results
    By GemBox in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-22-2017, 02:14 AM
  4. VBA VLookUp 1 condition return in 1 cell multiple results.
    By SistemasCalexico in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2017, 02:49 AM
  5. Trying to add multiple fields with a certain requirement
    By kenzie316 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2016, 12:26 PM
  6. [SOLVED] Multiple Condition with Multiple Results
    By dunerak in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-03-2015, 08:23 PM
  7. [SOLVED] Return multiple Results from an IF statement if more than one condition exists
    By mysticmoron109 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-28-2015, 02:45 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