cell(a1)="xx"

[jackw3306]

Is there a way in Excel to change a cell value from another cell?

Such as: =if (Cell(A2)= "1",cell(A1)="xx",cell(A1)="yy")

[DonkeyOte]

No, you would need to use VBA.... the only cell capable of updating the contents of A1 directly is A1 itself, ie

A1: =IF(A2=1,"xx","yy")

you can't have

A3: =IF(A2=1,A1="xx",A1="yy")

if that's what you mean... ?