If formula - which can resolve and look for text in 2 columns?

[Dark_Knight_897]

Hi Guys,

Newbie here, i wondered if anyone knows of an IF and formula which can look into two different columns and search for the word "clear"in both columns. If both clear then return "pass", if not then return "fail".

[oeldere]

@Dark_Knight_897

Welcome to the excel forum.

C7=IF(AND($A7="clear",$B7="clear"),"pass","fail") and drag down.

[BadlySpelledBuoy]

Another method (there are many ways of doing this)

=IF(COUNTIF(A7:B7,"clear")=2,"Pass","Fail")

BSB

[gondal]

Hi try>> =IF(AND(A7:B7="Clear"),"pass","Fail") confirm With CTRL+SHIFT+ENTER

Gondal

[Dark_Knight_897]

Hi guys,

Thankyou so much. I tried the first one, and its worked. Appreciate your help.

Im no good with these excel functions.

How did you guys get so good btw?

Thanks

DK.

[oeldere]

Glad I could help.

If you are satisfied with the solution, please mark the question solved.

You can add reputation by clicking on the star * add reputation.

[BadlySpelledBuoy]

How did you guys get so good btw?

Practice, practice, practice... And nececisty as spreadsheets and databases are my job.

BSB

[Dark_Knight_897]

Thanks. I get it. I do find it so difficult to work with formulas, they dont come naturally to me, and i dont use excel enough. I will need to practice. Any recommended places/forms/e-templates I can download which will help me improve with my Excel formula basics?