Combining words and nums.
Eddie wrote:
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="Ye s"),0,""))
|