Double if statement

[colmodoc]

Hi.
I'm trying to create a double IF statement which returns the value "Attended" in ColC where ColA contains "Confirmed" and ColB contains "Show".
Otherwise "Did not attend".
Thanks for looking.
[TABLE="width: 500"]
<tbody>[TR]
[TD]ColA[/TD]
[TD]ColB[/TD]
[TD]ColC (Desired Result)[/TD]
[/TR]
[TR]
[TD]Confirmed[/TD]
[TD]Show[/TD]
[TD]Attended[/TD]
[/TR]
[TR]
[TD]Confirmed[/TD]
[TD]Show[/TD]
[TD]Attended[/TD]
[/TR]
[TR]
[TD]Cancelled[/TD]
[TD]No Show[/TD]
[TD]Did not Attend[/TD]
[/TR]
[TR]
[TD]Confirmed[/TD]
[TD]No Show[/TD]
[TD]Did not Attend[/TD]
[/TR]
[TR]
[TD]Confirmed[/TD]
[TD]Show[/TD]
[TD]Attended[/TD]
[/TR]
[TR]
[TD]Cancelled[/TD]
[TD]No Show[/TD]
[TD]Did not Attend[/TD]
[/TR]
[TR]
[TD]Confirmed[/TD]
[TD]Show[/TD]
[TD]Attended[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[AlanY]

in C2, and copy down

=if(and(A2="Confirmed",B2="Show"),"Attended","Did not Attend")

 

[colmodoc]

Thank you Alan.

 

[AlanY]

you're welcome