IF Function - relating adjacent cell check

[rayted]

Hi guys,

I have 64 boxes from cell A2 downwards which say: 'S1' in all of the cells. In the 64 boxes from B2 downwards, I see a mixture of content including S1.

I want to write an IF statement saying if B2 has S1 (like A2), return: No change. If B2 has anything other than S1, return: Change

Can anyone help me to write this statement?

Thank you

[samba_ravi]

I think
=if(a2=b2,"No Change","Change")
if it is not work, please attach a sample excel file with expected result

[rayted]

I just figured it out!
=IF(B2 = A2, "No Change", "Change")

Yes you're one is acceptable too.

Thank you!

[modytrane]

In C2:
=IF(B2="S1", "No Change", "Change") copied down the column.
assuming A column has all S1.

[JohnTopley]

Try

=IF(AND(A2="S1",A2=B2),"No change","Change")

[pjwhitfield]

based on the question asked I would agree that John's is the only one that does what the OP asked (however it may be that the OP wasnt clear enough).