I've tried a few different things thinking I was on the right track based on the IF, and AND function.
I need to find if
cell A1 = "Yes" and B1 ="Yes" C1 = "Yes"
cell A1 = "Yes" and B1= "No" C1= "Yes"
cell A1= "No" and B1 ="Yes" C1= "Yes"
cell A1= "No" and B1 ="No" C1= "No"
cell A1= "Blank" C1 = "Blank"
I am not sure what formula to use for this
any help appreciated