RETURN FORMULA

Rob · Jul 30, 2003

I need a formula that would return a value IN CELL C1 of
YES if cells A1 & B1 have values of YES.

Dan E · Jul 30, 2003

=IF(AND(A1="YES", B1="YES"),"YES", "NO")

Dan E

Kerry · Jul 30, 2003

-----Original Message-----
I need a formula that would return a value IN CELL C1 of
YES if cells A1 & B1 have values of YES.
.

You can do this using the combination of the 'if'
and 'and' functions.

In cell c1 type "=if(and(a1="Yes",a2="Yes"),"Yes","No")

Jason Morin · Jul 30, 2003

In C1:

=IF(COUNTIF(A1:B1,"Yes")=2,"YES","")

HTH
Jason
Atlanta, GA

Alan Beban · Jul 30, 2003

=IF(AND(A1="yes",B1="yes"),"yes","no")

Alan Beban