Combining words and nums.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
Eddie said:
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
Click to expand...


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