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.

ColA	ColB	ColC (Desired Result)
Confirmed	Show	Attended
Confirmed	Show	Attended
Cancelled	No Show	Did not Attend
Confirmed	No Show	Did not Attend
Confirmed	Show	Attended
Cancelled	No Show	Did not Attend
Confirmed	Show	Attended

<tbody>
</tbody>

 

[AlanY]

in C2, and copy down

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

 

[colmodoc]

Thank you Alan.

 

[AlanY]

you're welcome