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")
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")