Logic Cell Letter Value VLookup or IF

[EXCELlent 2010]

I am looking for the most simple way to reflect "Y" in C3, from the indication that "Y" is displayed in both A3 and B3. I am very new to lookups, if statements, and all similar functions. I basically want to tell it "if A3 AND B3 are "Y" then C3 should be "Y"". I apologize if the title of the thread is not correct, I could not think of a better title. Thank you for your time and help, it is much appreciated.

Before

Coke	Pepsi	Coke/Pepsi
Y
Y	Y
	Y

<tbody>
</tbody>

And After

Coke	Pepsi	Coke/Pepsi
Y
Y	Y	Y
	Y

<tbody>
</tbody>

 

[T. Valko]

I am looking for the most simple way to reflect "Y" in C3, from the indication that "Y" is displayed in both A3 and B3. I am very new to lookups, if statements, and all similar functions. I basically want to tell it "if A3 AND B3 are "Y" then C3 should be "Y"". I apologize if the title of the thread is not correct, I could not think of a better title. Thank you for your time and help, it is much appreciated.

Before

Coke	Pepsi	Coke/Pepsi
Y
Y	Y
	Y

<TBODY>
</TBODY>

And After

Coke	Pepsi	Coke/Pepsi
Y
Y	Y	Y
	Y

<TBODY>
</TBODY>

Like this...

=IF(AND(A2="Y",B2="Y"),"Y","")

Copy down

 

[EXCELlent 2010]

Thank you for your swift response. I plugged it in, aboluted the columns A and B: =IF(AND($A2="Y",$B2="Y"),"Y",""), and dragged the formula down the entire column. Now on each row, I get a "Y" in column C no matter what is in column A or B. I don't understand why this is happening. Please shed light upon my darkness. I deeply appreciate your help, thanks again.

 

[T. Valko]

Thank you for your swift response. I plugged it in, aboluted the columns A and B: =IF(AND($A2="Y",$B2="Y"),"Y",""), and dragged the formula down the entire column. Now on each row, I get a "Y" in column C no matter what is in column A or B. I don't understand why this is happening. Please shed light upon my darkness. I deeply appreciate your help, thanks again.

Make sure calculation is set to Automatic.

 

[EXCELlent 2010]

That was it! Thanks again for your help.

 

[T. Valko]

That was it! Thanks again for your help.

You're welcome. Thanks for the feedback!