Results 1 to 3 of 3

Thread: IF AND and WILDCARDS

  1. #1
    Board Regular
    Join Date
    Sep 2018
    Posts
    79
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default IF AND and WILDCARDS

    I am performing an if formula that has 2 AND criteria, fo which one is a contains wildcard. I read that countifs may be the solution but I am still off the mark

    Can anyone help please?



    =IF(COUNTIFS(N6,">0",C6,"*CDITT*"),WORKDAY(N6,-Info!$J$12,FigWork!$B$18:$B$25),IF(COUNTIFS(N6,">0",C6,"<>*CDITT*"),WORKDAY(N6,-Info!$E$12,FigWork!$B$18:$B$25),0))

    Many thanks

  2. #2
    Board Regular steve the fish's Avatar
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,650
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    3 Thread(s)

    Default Re: IF AND and WILDCARDS

    Do you mean this?

    =IF(N6>0,IF(ISNUMBER(SEARCH("CDITT",C6)),WORKDAY(N6,-Info!$J$12,FigWork!$B$18:$B$25),WORKDAY(N6,-Info!$E$12,FigWork!$B$18:$B$25)),"")
    Looking for opportunities

  3. #3
    Board Regular
    Join Date
    Sep 2018
    Posts
    79
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: IF AND and WILDCARDS

    @steve the fish, brilliant thank you!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •