TSchneider,
You don't say what other cells may have yes/no so I assume that they are
N2, P2 & R2

For L1 & N1 try:

=(L2="Yes")*2

and for P1 & R1 try:

=(P1="Yes")*1

or
=--(P1="Yes")

To *combine* all answers in one cell use:

=L1&N1&P1&R1

or if you mean add up all the answers try:

=SUM(L1,N1,P1,R1)

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"TSchneider" wrote in message
...
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?