IF FUNC with multiple non-specific criteria?

[jandtng]

Ok I'm stump on this one. I'm trying to figure out a formula to give me a "No" or leave the cell blank in the yellow column.
If B1 is blank and C1 have any text/numbers, then D1 is "No".
If B2 have any text/numbers and C2 have any text/numbers, then leave D2 blank.
Unless I have a specific text or numbers in column B or C, the If function can't work. I tried using the asterisk in place of the text/numbers but it didn't work. TIA

 

[hagia_sofia]

Something like this (provided that you are only interested in cols B and C):

=IF(SUM(--(ISBLANK(B1:C1)))>0,"No","")

?

 

[NickFru]

Hello - try these, on the first formula;

=IF(B1="",""&IF(ISTEXT(C1), "No", ""),"")

With the second formula I have put a second condition just in case B2 and C2 are both blank with ab N/A;

=IF(ISTEXT(B2),"",IF(ISTEXT(C2),"","N/A")

 

[Cubist]

Ok I'm stump on this one. I'm trying to figure out a formula to give me a "No" or leave the cell blank in the yellow column.
If B1 is blank and C1 have any text/numbers, then D1 is "No".
If B2 have any text/numbers and C2 have any text/numbers, then leave D2 blank.
Unless I have a specific text or numbers in column B or C, the If function can't work. I tried using the asterisk in place of the text/numbers but it didn't work. TIA

View attachment 111602

What about when you have something in B but not C? What do you want to return in this case?

 

[jandtng]

What about when you have something in B but not C? What do you want to return in this case?

If there is somthing in B but not C, the return should be a blank cell

 

[Cubist]

If there is somthing in B but not C, the return should be a blank cell

Try this. I've included an array option in column E.

Book1
	A	B	C	D	E
1	Any Text		Any Text	No	No
2	Any Text	Any Text	Any Text
3	Any Text	Any Text
Sheet9

Cell Formulas
Range	Formula
E1:E3	E1	=IF((B1:B3="")*(C1:C3<>""),"No","")
D1:D3	D1	=IF((B1="")*(C1<>""),"No","")
Dynamic array formulas.

 

[jandtng]

Something like this (provided that you are only interested in cols B and C):

=IF(SUM(--(ISBLANK(B1:C1)))>0,"No","")

?

This partially worked.
When there is something in B and nothing in C, the return should be a blank cell
When there are something in both B and C, the return should be a blank cell

Something like this (provided that you are only interested in cols B and C):

=IF(SUM(--(ISBLANK(B1:C1)))>0,"No","")

?

 

[jandtng]

Try this. I've included an array option in column E.

Book1
	A	B	C	D	E
1	Any Text		Any Text	No	No
2	Any Text	Any Text	Any Text
3	Any Text	Any Text
Sheet9

Cell Formulas
Range	Formula
E1:E3	E1	=IF((B1:B3="")*(C1:C3<>""),"No","")
D1:D3	D1	=IF((B1="")*(C1<>""),"No","")
Dynamic array formulas.

Thank you!!! You are awesome, that formula works!!! What a great group this is. I'm learning so much!!!