RETURN FORMULA

[Rob]

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

 

[Dan E]

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

Dan E

 

[Kerry]

-----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]

In C1:

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

HTH
Jason
Atlanta, GA

 

[Alan Beban]

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

Alan Beban