Hello,

Trying to come up with a formula which would do - if A through E =Y
then H = YES else NO

i started with this but it does not work. =IF((E2:I2 = y), "YES","NO")


A B C D E H
Y Y Y Y Y
Y Y Y N Y

Thanks for the help!

=IF(COUNTIF(E2:I2,"y")=5,"YES","NO")
best wishes

--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

wrote in message
...
Hello,

Trying to come up with a formula which would do - if A through E =Y
then H = YES else NO

i started with this but it does not work. =IF((E2:I2 = y), "YES","NO")


A B C D E H
Y Y Y Y Y
Y Y Y N Y

Thanks for the help!

Try...

=IF(A2&B2&C2&D2&E2="YYYYY","Yes","No")

Hope this helps!

http://www.xl-central.com

In article
,
wrote:

Hello,

Trying to come up with a formula which would do - if A through E =Y
then H = YES else NO

i started with this but it does not work. =IF((E2:I2 = y), "YES","NO")


A B C D E H
Y Y Y Y Y
Y Y Y N Y

Thanks for the help!

On Wed, 1 Apr 2009 10:32:35 -0700 (PDT), wrote:

Hello,

Trying to come up with a formula which would do - if A through E =Y
then H = YES else NO

i started with this but it does not work. =IF((E2:I2 = y), "YES","NO")


A B C D E H
Y Y Y Y Y
Y Y Y N Y

Thanks for the help!

And another method:

This formula must be **array-entered**:

=IF(AND(E1:I1="Y"),"YES","NO")

To **array-enter** a formula, after entering
the formula into the cell or formula bar, hold down
<ctrl<shift while hitting <enter. If you did this
correctly, Excel will place braces {...} around the formula.
--ron

That will return "Yes" for combinations such as this one (and there are
*lots* more)...

A2="YY"
B2="Y"
C2=""
D2="YY
E2=""

--
Rick (MVP - Excel)


"Domenic" wrote in message
...
Try...

=IF(A2&B2&C2&D2&E2="YYYYY","Yes","No")

Hope this helps!

http://www.xl-central.com

In article
,
wrote:

Hello,

Trying to come up with a formula which would do - if A through E =Y
then H = YES else NO

i started with this but it does not work. =IF((E2:I2 = y), "YES","NO")


A B C D E H
Y Y Y Y Y
Y Y Y N Y

Thanks for the help!

It doesn't look like that's going to be the case. Nevertheless, it
should have been pointed out. Thanks Rick!

In article ,
"Rick Rothstein" wrote:

That will return "Yes" for combinations such as this one (and there are
*lots* more)...

A2="YY"
B2="Y"
C2=""
D2="YY
E2=""

--
Rick (MVP - Excel)


"Domenic" wrote in message
...
Try...

=IF(A2&B2&C2&D2&E2="YYYYY","Yes","No")

Hope this helps!

http://www.xl-central.com

In article
,
wrote:

Hello,

Trying to come up with a formula which would do - if A through E =Y
then H = YES else NO

i started with this but it does not work. =IF((E2:I2 = y), "YES","NO")


A B C D E H
Y Y Y Y Y
Y Y Y N Y

Thanks for the help!