R
Rob
I need a formula that would return a value IN CELL C1 of
YES if cells A1 & B1 have values of YES.
YES if cells A1 & B1 have values of YES.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dan E
=IF(AND(A1="YES", B1="YES"),"YES", "NO")
Dan E
Dan E
K
Kerry
You can do this using the combination of the 'if'-----Original Message-----
I need a formula that would return a value IN CELL C1 of
YES if cells A1 & B1 have values of YES.
.
and 'and' functions.
In cell c1 type "=if(and(a1="Yes",a2="Yes"),"Yes","No")
J
Jason Morin
In C1:
=IF(COUNTIF(A1:B1,"Yes")=2,"YES","")
HTH
Jason
Atlanta, GA
=IF(COUNTIF(A1:B1,"Yes")=2,"YES","")
HTH
Jason
Atlanta, GA
A
Alan Beban
=IF(AND(A1="yes",B1="yes"),"yes","no")
Alan Beban
Alan Beban