+ Reply to Thread
Results 1 to 3 of 3

Display Blank If Condition Is Met

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2010
    Posts
    63

    Display Blank If Condition Is Met

    Hi all,

    The two formulas below are used for splitting a cell reference in two after the "-"

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I need to be able to add an extra formula to the above which will only display if the source cell of the reference is NOT "0000 - Extra Core Hours"

    Any ideas on how to do this?

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Display Blank If Condition Is Met

    May be this:
    =IF(E3="0000 - Extra Core Hours",E3,TRIM(......))
    OR
    =IF(E3="0000 - Extra Core Hours","",TRIM(......))
    Quang PT

  3. #3
    Registered User
    Join Date
    11-07-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2010
    Posts
    63

    Re: Display Blank If Condition Is Met

    Managed to get it working using the 2nd formula. Thank you very much bebo!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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