Hi,

When will you apply formula on 'J' cell then it will show the actual result of calculation done by applied formula, It does not matter that what you have already set in 'J' cell.

Can you please share sample of your data ? So that i could explain it more.