Excel if and formula

[Amy24]

Hi I have a spreadsheet with column c2 showing either a number or blank and I have data in w2 either being warehouse, direct supply or direct delivery, I need D2 to tell me if c2 is blank and w2 is direct supply or direct delivery "pod needed", if c2 not blank I need it to say "have pod" and if w2 is warehouse it needs to return either "have pod" if value in c2 or "warehouse investigation" if blank.
I have tried if and formula but it's not returning correctly

 

[gordsky]

Hi I have a spreadsheet with column c2 showing either a number or blank and I have data in w2 either being warehouse, direct supply or direct delivery, I need D2 to tell me if c2 is blank and w2 is direct supply or direct delivery "pod needed", if c2 not blank I need it to say "have pod" and if w2 is warehouse it needs to return either "have pod" if value in c2 or "warehouse investigation" if blank.
I have tried if and formula but it's not returning correctly

could you attach a sample sheet showing what you expect the results to be

 

[Peter_SSs]

Welcome to the MrExcel board!

From what I can gather, this is what you are asking. If not then, as @gordsky has requested, we would need some more varied sample data and expected results. Investigate XL2BB for that.

22 02 20.xlsm
	C	D																			W
1
2	3	have pod																			direct supply
3		pod needed																			direct supply
4	18	have pod																			direct delivery
5		pod needed																			direct delivery
6	45	have pod																			warehouse
7		warehouse investigation																			warehouse
Amy24

Cell Formulas
Range	Formula
D2:D7	D2	=IF(C2="",IF(W2="warehouse","warehouse investigation","pod needed"),"have pod")

 

[Amy24]

Thank you so much that's perfect

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.