IF AND and WILDCARDS

horizonflame

Board Regular
Joined
Sep 27, 2018
Messages
154
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
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
7,879
Office Version
365
Platform
Windows
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)),"")
 

Forum statistics

Threads
1,089,185
Messages
5,406,689
Members
403,103
Latest member
mkirchner

This Week's Hot Topics

Top