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?

Ok.. Let me see if I understand you correctly...

N2 & I2 = IF(L2="yes", 2, IF(L2="no", 0, False))

P2 & R2 = IF(L2="yes", 1, IF(L2="no", 0, False))

Your cell that combine all the values can be..

IF(L2="yes", 6, IF(L2="no", 0, False))


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=561573

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?

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?