On Thu, 3 Mar 2005 12:31:05 -0800, "LostNFound" wrote:
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
Using IF statements:
=IF(AND(A1=1,B1="Yes"),1,IF(AND(A11,B1="Yes"),2,0 ))
Different and perhaps more obscu
=(A11)*(B1="Yes")*2+(A1=1)*(B1="Yes")
--ron
|