Is there a method to apply this formula in B2 to work for any two adjacent cells (eg. G1&H1 , R55&S55 , W101&X101 .. etc):
B2=the original value of B2 -(C2*0.01)
So that, I just select the cell (B2 in my example), and by applying that method, the new result overwrites the original value of the same cell.
Is that applicable?
Thanks in advance.