+ Reply to Thread
Results 1 to 6 of 6

IF Regular or Standard Hours show as "Regular,Standard"

  1. #1
    Registered User
    Join Date
    01-24-2017
    Location
    Glasgow
    MS-Off Ver
    2013
    Posts
    64

    IF Regular or Standard Hours show as "Regular,Standard"

    Hiya,

    Where I have the type of hours in cell A1 (Regular, Standard, Overtime, Unpaid, Travel) I would like the adjacent column to pull and "Regular" and "Standard" hours into column B and shows as "Regular,Standard", where it is not either of these column B should just replicate what is in the cell in column A.

    I already have a start where I can get the Regular and Standard elements to work. I just need the final part where the cell value pulls over and shows as is if it does not match regular or standard.

    =IF(OR(A1="Regular",A1="Standard"),"Regular,Standard","")

    Thanks in advance.
    Attached Files Attached Files
    Last edited by BigErnKingpin; 09-03-2019 at 04:25 AM.

  2. #2
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,317

    Re: IF Regular or Standard Hours show as "Regular,Standard"

    Come on now!! You should know by now that a sample sheet will help greatly.
    Glenn



  3. #3
    Registered User
    Join Date
    01-24-2017
    Location
    Glasgow
    MS-Off Ver
    2013
    Posts
    64

    Re: IF Regular or Standard Hours show as "Regular,Standard"

    Glenn you are killing me lol. Attaching now

  4. #4
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    388

    Re: IF Regular or Standard Hours show as "Regular,Standard"

    Why you set the null string when the criteria is FALSE :D
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-24-2017
    Location
    Glasgow
    MS-Off Ver
    2013
    Posts
    64

    Re: IF Regular or Standard Hours show as "Regular,Standard"

    Thanks for the fix!

  6. #6
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    388

    Re: IF Regular or Standard Hours show as "Regular,Standard"

    You are welcome!

+ 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. Regular Expression to Return "True" or False" if a word is found
    By wwconslt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2017, 09:54 PM
  2. Replies: 5
    Last Post: 03-10-2016, 04:04 PM
  3. [SOLVED] Regular Expressions Match "n-#"
    By k64 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-28-2014, 09:22 PM
  4. Concatenate regular expressions AND searching for "=" character
    By AnnieMcken in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-07-2014, 11:41 AM
  5. Replies: 2
    Last Post: 08-20-2012, 12:25 AM
  6. Convert Pivot Table data to "regular" format
    By bronsonb in forum Excel General
    Replies: 1
    Last Post: 02-24-2011, 12:24 AM
  7. Set "Show Standard and Formatting toolbars on two rows" to True
    By MartinShort in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2009, 01:33 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