=IF(B1="",0,IF(AND(A1=1,B1="Yes"),1,IF(AND(A11,B1 ="Yes"),2,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"LostNFound" wrote in message
...
I want to use two criterias for an answer?? If Column A contains a 1 and
Column B says Yes then return a 1 But if column B is blank return 0.. Then
at
the same time if column A contains anything 1 and Column B says Yes
return a
2 but if column B is blank return zero


Thanks For any suggestions
M