Excel, how to change text in cell depending on another cell value

I am trying to change a text in the cell A1 from "No" to "Yes" by using a formula in A3.

Exempel, i am using cell A1, A2 and A3

A1 contains the text i want to change, "No".

A2 contains the text "1".

A3 is my formula to make magic happen.

In A3 i have tried to make an if startment as following "=if(1=A2,A1 = "Yes")"

But this does not change the text in A1 to "Yes" so do you guys have any ideas how i can make this work?