IF & ELSE IF formula

[dc4000]

Formula for this:

If column C= "Y" then amend column A "ABCDE" but what if column ="N" then i want to leave column A with value already contained in that cell

 

[Joe4]

A worksheet formula can only return a value to the cell that it is located in. So, if this formula is in column A, you cannot also have a hard-coded value in column A
To do something like this will require VBA. Is that acceptable?

If so, please give us a few details to help you write this:
1. When do you want this to occur? Do you want to call/run the macro manually, or should it happen automatic as someone manually updates the value in column C?
2. Should this pertain to ALL of column A/C, or just a certain range (if just a certain range, please disclose the limitations)?