If function to return multiple conditions

[TrishaL]

Hello

Looking for help to write a formula that will give me the result of column "C" below.
Tried this in my excel and obviously not working.... =IF(AND(COUNTIF((AH287="*team*", AJ287=1), "Yes", ""), (AH287="*team*"), AJ287=""), "Pending", ""))
I want it to return Yes if Team and a date, if Team and no date return Pending... everything else just blank.

Thanks in advance

A	B	C
team	23-Jan-19	Yes
single
team		Pending
"this is empty cell"
team	23-Jan-19	Yes
single
"this is empty cell"
team		Pending
team	23-Jan-19	Yes

<colgroup><col><col><col></colgroup><tbody>
</tbody>

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[Fluff]

Maybe

Excel 2013/2016
	A	B	C
1	A	B
2	team	23-Jan-19	Yes
3	single
4	team		Pending
5
6	team	23-Jan-19	Yes
7	single
8
9	team		Pending
10	team	23-Jan-19	Yes
Sheet3

Cell Formulas
Range	Formula
C2	=IF(A2<>"Team","",IF(B2>0,"Yes","Pending"))

 

[TrishaL]

Hi
Thank you. Way better than what I had but when i put it in it gives "pending" result on the single and the cells with no data. The "yes" is correct and "pending" where there is team.
Is there a way to show a result of blank on "single" and blank cells?
Thanks

 

[Fluff]

Are your actual values "Team" and "Single", or are they something else?

 

[TrishaL]

Hi
They will actually say ".....text.... Team .... text".
The other cells in that column are either blank, or may say "removed.....text..." or "not required......text..."
In your formula I entered * around team. I did this: =IF(AH286="*Team*","",IF(AJ286>0,"Yes","Pending"))

 

[Fluff]

It should be AH286<>"*Team*"

 

[TrishaL]

Hi
When I put in AH286<>"*Team*" instead of the = then the when i have "team" and "date" the result is blank and not yes.
Sorry but it just isn't giving the answer.
Thanks

 

[horrellbt01]

This should work as well:

=IF(OR(A1="<>",B1="<>",C1="<>")=FALSE,"","Yes")

If any of the cells in A1:C1 are blank it will return a blank, otherwise it will return "Yes"

 

[Fluff]

How about

Excel 2013/2016
	A	B	C
1	A	B
2	a team	23-Jan-19	Yes
3	single
4	team b		Pending
5
6	steaming	23-Jan-19	Yes
7	single
8
9	team		Pending
10	team	23-Jan-19	Yes
Sheet3

Cell Formulas
Range	Formula
C2	=IF(ISNUMBER(SEARCH("team",A2)),IF(B2>0,"Yes","Pending"),"")

 

[TrishaL]

Hi
This works wonderfully. Sorry for the late reply! Thank you so much!