Return Value Yes based on 2 cells

[Johnboy28]

I cant seem to get this to work - If cell "weight" and cell "Include = yes and weight =o, return "Don’t Include" & if cell "weight" and cell "Include = yes and weight = greater than Zero return "Include"

So If cell equals "YES" and has a greater weight of Zero - Return "Include" otherwise Return "Don't Include"

Thank you

Weight	Include	Answer
24	yes	Include
0	yes	Don’t Include
50	no	Don’t Include
44	yes	Include
0	no	Don’t Include

 

[AlanY]

try =IF(AND(A2>0,B2="yes"),"Include","Don't Include")

 

[Johnboy28]

Thank you. Thanks works great.

 

[AlanY]

Thank you. Thanks works great.

you're welcome