Detecting "errors" in formulas

[Vuko32]

Hi everyone, sorry for language misstakes first, but i'll try to do my best to elaborate problem.

I have some problem with detecting "errors" in formulas.

I have table with simple formula, example, in cell F6 is "=ROUND(D6*E6;2)".

How can i check that in that cell F6 are exactly D6 and E6, or to put it other way, how to check that in formula there are cells frome same row that formula is.

I have large data tables with thousands of rows, and sometimes when copying and moving, and shifting rows, data and all, my formula has "errors" when it multiplys cells from different row.

I'll put a picture to give example and to be more clear what i'm asking.

Ok, so "error" in this example is in row 7 and 8. The formula is multiplying wrong cells, cells from differnet rows. How to detect this through the whole sheet.

Thanks.

 

[Vuko32]

I'm also uploading example file to work on

https://ufile.io/uh7hy

Thanks

 

[Fluff]

Cross posted https://www.excelforum.com/excel-general/1260623-detecting-errors-in-formulas.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.