+ Reply to Thread
Results 1 to 2 of 2

If(OR) Function with CONCATENATE

  1. #1
    Registered User
    Join Date
    04-13-2014
    Location
    Skipton, England
    MS-Off Ver
    Excel 2007
    Posts
    23

    If(OR) Function with CONCATENATE

    Hi guys,

    Tried building a formula yesterday but power went in the office yesterday and lost it and struggling to get it to work again,

    =IF(OR('Data Input Tab'!E27="",'Data Input Tab'!E28=""),"Insufficient data input to make calculation",CONCATENATE(" your ",'Data Input Tab'!D24," fund has ",IF('Data Input Tab'!E27<E28,"underperformed the sector in the 0-12 month period","outperformed the sector in the 0-12 month period"))),

    This formula works fine but then I want to basically duplicate this and search different cells, however without the (" your ",.........fund has ", aspect of the formula. e.g.

    =IF(OR('Data Input Tab'!E27="",'Data Input Tab'!E28=""),"Insufficient data input to make calculation",CONCATENATE(" your ",'Data Input Tab'!D24," fund has ",IF('Data Input Tab'!E27<E28,"underperformed the sector in the 0-12 month period","outperformed the sector in the 0-12 month period"))),IF(OR('Data Input Tab'!F27="",'Data Input Tab'!F28=""),"Insufficient data input to make calculation",CONCATENATE(IF('Data Input Tab'!F27<F28,"underperformed the sector in the 13-24 month period","outperformed the sector in the 13-24 month period")))

    However this just returns a FALSE value so I'm clearly missing something...

    Any of you experts spot the mistake?

    Any help greatly appreciated.

    Cheers

    Rick

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,959

    Re: If(OR) Function with CONCATENATE

    I would do it like this:

    =TRIM(IF(OR('Data Input Tab'!E27="",'Data Input Tab'!E28=""),"Insufficient data input to make calculation",CONCATENATE("Your ",'Data Input Tab'!D24," fund has ",IF('Data Input Tab'!E27<E28," underperformed the sector in the 0-12 month period"," outperformed the sector in the 0-12 month period")," and ",IF('Data Input Tab'!F27<F28," underperformed the sector in the 13-24 month period."," outperformed the sector in the 13-24 month period."))))
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Using the CONCATENATE function nested in an IF function
    By rottweiler_lvr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-07-2013, 10:02 PM
  2. [SOLVED] Concatenate Function
    By bjelmer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-21-2012, 11:19 AM
  3. Concatenate Function
    By pradeepdeepu_001 in forum Excel General
    Replies: 2
    Last Post: 01-21-2011, 06:51 AM
  4. Concatenate Function
    By billykiller05 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-15-2010, 11:29 AM
  5. Concatenate function
    By pboost1 in forum Excel General
    Replies: 1
    Last Post: 03-02-2005, 03:52 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