Formula cell value change

[Closed]
Report
-
Hello,

I have 2 columns..... say A & B

If I type "Approved" in Column B1, then A1 should automatically change to "COMPLETED"

If I type any other words other than "Approved" or even Column B1 is empty, then Column A1 should stay in same old value, not even change to FALSE.....

These formula i need to populate throughout the column B

Thanks....