I'm not sure if this answers your question . . . but from as I understand,
there are two parts. You'll need to change it up for your references/needs.

To analyze the data in a particular cell:
=IF(A1="yes",2,IF(A1="no",0,"error"))

To analye the data in all of the returning cells:
=IF(AND(B1=2,B2=2,c2=2,d2=2),"True","False")

"TSchneider" wrote:

I am trying to create a formula where if L2=yes then the values is 2, if no
then it is 0. I need to have 4 colums set up this way (l,N,P &R except P&R
value is 1 instead of 2) and the answer of all 4 combined in once cell. How
do I do that?