I need help with a formula values

[Guest]

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?

 

[Bearacade]

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))

 

[Guest]

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")

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk