How to prevent IF function from removing cell data when false

SuperDigital

My team is currently tracking customer services and monthly rate before and after talking with an agent, using a form that I created. I am trying to set up a formula that if we select that there are no changes made to the account it will copy over the data from the incoming fields to the outcoming. I am using this IF formula:

=IF([Was there a change to the service?]@row = "Service Not Changed", ([Outcoming MRC]@row=[Incoming MRC]@row).

This formula works if there was no changes made, but if changes were made the function is erasing the data that was inputted through the form. Is there anyway to prevent the data from being erased? Is there maybe a better way to do what i'm trying to do? Any help would be greatly appreciated.

Paul Newcome

Are you able to provide a screenshot for context?

SuperDigital

My apologies should have attached that originally. Currently we are manually updating the outcoming fields when the services are not changed but im essentially trying to automate that process.

Paul Newcome

If there is a change and you need to be able to log that in the column then you will need to leave all rows as manual entry. You cannot have both a formula and manual entry within the same cell.

SuperDigital

I was afraid you were going to say that LOL. Thanks for the help Paul!