If formula

[xxsalahxx]

Hello

I have a formula that I am using and I would like to add to it if its possible.
So for example if in cell A2 there is a yes or/and cell B2 is a yes then enter a yes in cell C or enter no, ive mastered that part (i think), however I would like to add to this to say if A2 or B2 has the word cancelled i would like for cell C2 to say cancelled is this possible?

=IF(OR(A2="Yes",B2="Yes"),"Yes","No")

 

[Fluff]

How about

=if(or(a2="cancelled",b2="cancelled"),"cancelled",IF(OR(A2="Yes",B2="Yes"),"Yes","No"))

 

[xxsalahxx]

Thats perfect thank you. very much appreciated.

=if(or(a2="cancelled",b2="cancelled"),"cancelled",IF(OR(A2="Yes",B2="Yes"),"Yes","No"))

If i take it one step further ...sorry ive came across another one saying unknown so if A2 or b2 says unknown can this be done?

 

[Fluff]

Just add another IF for that that in the same way I did for the cancelled

 

[xxsalahxx]

Thank you so much, perfect

 

[Fluff]

You're welcome & thanks for the feedback.