P
patele
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!
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!