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