Nesting Functions

[LostNFound]

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

 

[Dave R.]

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

 

[Bob Phillips]

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

--

HTH

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

 

[Dave R.]

ignore this, use bob's. forgot you wanted to only look fro B being BLANK.

 

[Ron Rosenfeld]

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(A1>1,B1="Yes"),2,0))

Different and perhaps more obscure:

=(A1>1)*(B1="Yes")*2+(A1=1)*(B1="Yes")


--ron