If formula

[Smudge80]

Hi Guys, hoping someone can help me with below.
Looking for formula that returns yes in
A5 if yes is entered in any cell range between A1:D1
Return no if not
Thanks in advance!

 

[Smudge80]

Apologies meant returns yes in E1 not A5

 

[James006]

Hello,

You could test the following

=IF(ISERROR(MATCH("yes",A1:D1,0)),"No","Yes")

HTH

 

[nanndu141]

Please enter the below formula and hit Ctrl+Shift+Enter.
=IF(OR(A1:D1="Yes"),"Yes","No")

Regards
Nandu

 

[Aladin Akyurek]

=COUNTIFS(A1:D1,"yes")+0

or

=ISNUMBER(MATCH("yes",A1:D1,0))+0

Custom format the formula cell as:

[=0]"";[>0]"yes";General

 

[Smudge80]

=COUNTIFS(A1:D1,"yes")+0

or

=ISNUMBER(MATCH("yes",A1:D1,0))+0

Custom format the formula cell as:

[=0]"";[>0]"yes";General

Not liking that formula I’m afraid...

 

[Aladin Akyurek]

Not liking that formula I’m afraid...

What does it say? What is your version of Excel?

 

[Smudge80]

Seems a tricky one to crack,
Was close on =if(countif(A1:D1,’’’’),’’’’,IF,(COUNTIF)A1:D1,’’NO,IF(COUNTIF(A1:D1,’’yes’’)=4,”yes”)))

Unfortunately this only returns yes if all 4 cells say yes when I want it to return yes if any cell in that range is yes

 

[Aladin Akyurek]

Seems a tricky one to crack,
Was close on =if(countif(A1:D1,’’’’),’’’’,IF,(COUNTIF)A1:D1,’’NO,IF(COUNTIF(A1:D1,’’yes’’)=4,”yes”)))

Unfortunately this only returns yes if all 4 cells say yes when I want it to return yes if any cell in that range is yes

In E1 enter:

=COUNTIFS(A1:D1,"yes")+0

Now select E1; right click > Format Cells > Custom; now type in the box:

[=0]"No";[>0]"Yes";General

You can now copy the formula down if so desired.

 

[r1998]

Hello Smudge80
use this formula in cell e1

=IF(COUNTIF(A1:D1,"yes")>0,"yes","")