Formula (If cell contains text or blank....)

[kismatstha]

I want to create a formula in excel for following condition:

1.If the cell A2 contains something (text), Give yes otherwise no in cell B2
2.If the cell A2 contains blank, Give blank in cell B2.

I tried with If function with Isnumber and IF error but couldnt succeeded. Could somebody please help?

 

[mole999]

maybe =IF(ISTEXT(A2),"Yes","")

 

[Peter_SSs]

Welcome to the MrExcel board!

Possibly these? In No. 2 you didn't say what to give if A2 does not contain a blank.

=IF(A2="","no","yes")

=IF(A2="","",A2)

 

[kismatstha]

Hello,
thank you fotr the quick response. Sorry I mislead you from the previous question. Actually I need one formula for those all conditions.

So again,
If cell A2 contains some specific text, give YES, if not then give no and if the cell A2 is blank, then give blank. I hope I dont confuse you.

 

[Peter_SSs]

=IF(A2="","",IF(A2="specific text","yes","no"))

 

[kismatstha]

=IF(A2="","",IF(A2="specific text","yes","no"))

Hello Peter,
Thank you for the help. What if one condition is added, could you please help? So again,
If the cell A2 contains something ( Redlining in my case, please see image attached), Give "yes" in cell B2 while if the cell doesn't contain that word, then give No and also
If the cell A2 contains blank or specific text ( | Final CAE in my case) Importantly | Final CAE has to exist alone in the cell not with other words in the cell) , then give blank in cell B. Please find the edited image.

 

[mole999]

you can learn to do these IF takes the arguments, What do you want to test for result, TRUE or FALSE i.e.
,IF(A2="specific text","yes","no"), you learn more from trying

 

[Peter_SSs]

See if this is it.

20 09 14.xlsm
	A	B
1
2	| Redlining | NF no | Final CAE	Yes
3
4	| Clean Copy | NF yes | Final CAE	No
5	| Final CAE
IF

Cell Formulas
Range	Formula
B2:B5	B2	=IF(OR(A2="",A2="| Final CAE"),"",IF(ISNUMBER(SEARCH("| Redlining",A2)),"Yes","No"))

 

[kismatstha]

See if this is it.

20 09 14.xlsm
	A	B
1
2	| Redlining | NF no | Final CAE	Yes
3
4	| Clean Copy | NF yes | Final CAE	No
5	| Final CAE
IF

Cell Formulas
Range	Formula
B2:B5	B2	=IF(OR(A2="",A2="| Final CAE"),"",IF(ISNUMBER(SEARCH("| Redlining",A2)),"Yes","No"))

Hello Peter,
That worked perfectly. Thank you for the time and help.

 

[Peter_SSs]

Hello Peter,
That worked perfectly. Thank you for the time and help.

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