Formula is removed when cell isnt active

[ipbr21054]

Hi,
Ive been working on trying to find out why formula in two columns is removed when i leave the cell.

I have supplied a file which can be looked at.
SAMPLE FILE

The columns in question are D & F & have IF statements in them.
Column E also has a IF state there but isnt affected

I started off removing all the code for the worksheets all aprt from the one left in the file.
The issue was still present.
I then deleted all the other worksheets.
The issue was still present
I deleted basically evertyhing as i tested before & after deleting.
The issue was still there.

So apart from the one worksheet im now wondering what is causing it as the issue is still there.

Please if you have time take a look & see if anything springs to mind
Thanks

 

[Fluff]

Duplicate to: Unable to put IF statement in cell sucessfully

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.