Cells with IF functions somehow linked

John M Lee

I have 2 columns on sheet A, each with a large IF statement. They both look to fields on sheet B (the same sheet but different fields). For some reason if on field updates, it updates the other field. They are not linked or copied in any way. I've manually rewritten each IF statement more than once.

No matter what I change in 1st Orders Ship from CS or in 1st Orders Arrive at WM DCs, upon save and refresh, they update to be the same formulas. ??

Paul Newcome

Remove both formulas, log out, clear your browser's cookies and cache, log back in, and then re-enter the formulas.