Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining words and nums.
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining words and nums.
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" 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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,"")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|