Combining words and nums.

[Guest]

I would like to know if there is a way that i can compare a yes and no
function and get a number answer from a previous row. See example below. I
want to put a formula in Colum D with the following rules : Colum D = Colum A
if Colum B is Yes and Colum C is no.
I would also like Colum D to equal 0 if Colum B is No and Colum C is Yes.


Colum A Colum B Colum C Colum D
65 Yes No ______
75 No Yes ______


Thank you,
Eddie

 

[Guest]

What if B & C are BOTH Yes or BOTH No?

In col D (this sets col D = col A *ONLY* when B is Yes and C is No. In all
other cases D=0

=IF(and(b1="yes",c1="no"),a1,0)

 

[Mark]

I would like to know if there is a way that i can compare a yes and no
function and get a number answer from a previous row. See example below. I
want to put a formula in Colum D with the following rules : Colum D = Colum A
if Colum B is Yes and Colum C is no.
I would also like Colum D to equal 0 if Colum B is No and Colum C is Yes.


Colum A Colum B Colum C Colum D
65 Yes No ______
75 No Yes ______


Thank you,
Eddie

Try this....
=IF(AND(B1="yes",C1="no"),A1,IF(AND(B1="No",C1="Yes"),0,""))