+ Reply to Thread
Results 1 to 3 of 3

Multiple IF and CONCATENATE

  1. #1
    Registered User
    Join Date
    01-24-2016
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    2

    Multiple IF and CONCATENATE

    Hi experts,
    Can anyone help me complete this formula or provide the correct formula to perform similar action.

    =IF(C9="Condition1",CONCATENATE("Text1 ",D9," Text2 ",TEXT(E9,"DD/MM/YYYY"),". Text3 ",F9," Text4 ",G9," Text5.") ,IF(C9="Condition2",CONCATENATE("Text1 ",TEXT(E9,"DD/MM/YYYY"),", Text2 ",D9," Text3 ",G9," to ",F9,"."),IF(C9="Condition3",CONCATENATE(G9," Text1 ",B6," Text2 ",F9," Text3 ",TEXT(E9,"DD/MM/YYYY"),”

  2. #2
    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,193

    Re: Multiple IF and CONCATENATE

    This ...???

    =IF(C9="Condition1",CONCATENATE("Text1 ",D9," Text2 ",TEXT(E9,"DD/MM/YYYY"),". Text3 ",F9," Text4 ",G9," Text5."),IF(C9="Condition2",CONCATENATE("Text1 ",TEXT(E9,"DD/MM/YYYY"),", Text2 ",D9," Text3 ",G9," to ",F9,"."),IF(C9="Condition3",CONCATENATE(G9," Text1 ",B6," Text2 ",F9," Text3 ",TEXT(E9,"DD/MM/YYYY")),"")))

  3. #3
    Registered User
    Join Date
    01-24-2016
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    2

    Re: Multiple IF and CONCATENATE

    It worked. I really appreciate your help.
    Thanks.

+ 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 concatenate function
    By i82 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-15-2013, 09:40 AM
  2. Concatenate multiple row in single row-
    By visha_1984 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-07-2013, 06:48 AM
  3. Concatenate with Multiple Criteria
    By mahesh8498 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-15-2012, 10:36 AM
  4. Multiple Lookup Criteria and Concatenate Multiple Results
    By Elwood07 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2012, 10:27 AM
  5. Concatenate with multiple alignment
    By tigabalm in forum Excel General
    Replies: 2
    Last Post: 04-04-2011, 09:53 PM
  6. Using CONCATENATE function with multiple ifs
    By WondersAlo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-05-2007, 07:58 PM
  7. Multiple IF statement with CONCATENATE
    By dadm20 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-19-2007, 09:48 PM
  8. Concatenate Multiple Cells
    By Sonya795 in forum Excel General
    Replies: 4
    Last Post: 08-22-2005, 03:51 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