If Function - 4 results needed

[TrishaL]

Hi

Needing help with this. What i have is not working, obviously. Below are 4 scenarios and I need results for all 4.
I have this =IF(ISNUMBER(SEARCH("*",AN32)),IF(AO32>0,"Yes","Pending"),"") from my spreadsheet but I don't know how to change it for what i now need below. What i have below in the "D (Results)" column is the answer i want the formula to give me.
Any help would be appreciated.
Thanks
[TABLE="width: 652"]
<colgroup><col><col span="4"></colgroup><tbody>[TR]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col span="4"></colgroup><tbody>[TR]
[TD][TABLE="width: 651"]
<tbody>[TR]
[TD]
[/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D (RESULTS)
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]38290-IOS-PC9540
[/TD]
[TD]30-Aug-18
[/TD]
[TD]TRUE
[/TD]
[TD]Yes
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]38290-IOS-PC9541
[/TD]
[TD]30-Aug-18
[/TD]
[TD]FALSE
[/TD]
[TD]Pending
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]38290-IOS-PC9542
[/TD]
[TD]
[/TD]
[TD]FALSE
[/TD]
[TD]Pending
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]"empty cell"
[/TD]
[TD]"empty cell"
[/TD]
[TD]FALSE
[/TD]
[TD]No or leave empty
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 652"]
<colgroup><col><col span="4"></colgroup><tbody></tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott Huish]

Why this ISNUMBER SEARCH why not just check for AN32<>""

Why is your formula referring to cells AN32 and AO32 when your range is in A:C?

Based on your sample though:
=IF(C2,"Yes",IF(COUNTA(A2:B2),"Pending","No"))

Excel 2010
	A	B	C	D
1	A	B	C	D (RESULTS)
2	38290-IOS-PC9540	30-Aug-18	TRUE	Yes
3	38290-IOS-PC9541	30-Aug-18	FALSE	Pending
4	38290-IOS-PC9542		FALSE	Pending
5			FALSE	No
Sheet1

Cell Formulas
Range	Formula
D2	=IF(C2,"Yes",IF(COUNTA(A2:B2),"Pending","No"))
D3	=IF(C3,"Yes",IF(COUNTA(A3:B3),"Pending","No"))
D4	=IF(C4,"Yes",IF(COUNTA(A4:B4),"Pending","No"))
D5	=IF(C5,"Yes",IF(COUNTA(A5:B5),"Pending","No"))

 

[jimrward]

Can you supply more info as to your rules for each scenario and how you arrive at the result

 

[TrishaL]

I copied the formula from my spreadsheet -- those are the columns/rows my data is actually in. sorry about that.

 

[TrishaL]

Column
A - needs data
B - needs a date
C - will be True or False
D - If A and B have data and C is True, then return "Yes". If A and B have data and C is False, then return "Pending". If A has data but B is empty and C is False then return "Pending". The last scenario is A is empty, B is empty and C is False, then return "No" or just return blank cell.
Thanks

 

[TrishaL]

I have tried what you provided but this won't exactly work as my columns aren't actually next to each other.
A is actually on AT
B is actually on AZ
C is actually on BI

Thanks,

 

[Scott Huish]

It should, just adjust the ranges:

=IF(BI2,"Yes",IF(COUNTA(AT2,AZ2),"Pending","No"))

Excel 2010
	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ
1
2	38290-IOS-PC9540						30-Aug-18									TRUE	Yes
3	38290-IOS-PC9541						30-Aug-18									FALSE	Pending
4	38290-IOS-PC9542															FALSE	Pending
5																FALSE	No
Sheet1

Cell Formulas
Range	Formula
BJ2	=IF(BI2,"Yes",IF(COUNTA(AT2,AZ2),"Pending","No"))
BJ3	=IF(BI3,"Yes",IF(COUNTA(AT3,AZ3),"Pending","No"))
BJ4	=IF(BI4,"Yes",IF(COUNTA(AT4,AZ4),"Pending","No"))
BJ5	=IF(BI5,"Yes",IF(COUNTA(AT5,AZ5),"Pending","No"))

 

[TrishaL]

Hi
Thank you for the response. So I figured out why this is not working. My data is taken from Access to Excel. In the table you put about for the scenario in Row 5 the result i was getting was "Pending" which was not the desired result. I have found that if i go to column AT and delete the empty cells then the formula works and returns a "No". For some reason it thinks there is data there and there isn't. Is there a way around this? I could always filter blank cells in this column and then delete. Let me know if you have any ideas. Thank you so much!

 

[Scott Huish]

=IF(BI2,"Yes",IF(AT2&AZ2="","No","Pending"))

 

[TrishaL]

Hello
Thank you this works!! Appreciate all of your help!