I have a data table that looks something like this, only with significantly more rows. In this data, PR+TC=GL for each set of data in column A. So, for example,
12345 PR + 12345 TC = 12345 GL. In this case $20 + $40 = $75, which is not correct. When it isn't correct, I need the difference to come from the number in the TC row -- so in this example, the TC row would change from $40 to $55. Is it possible to create a formula to do this?
so in this example, the TC row would change from $40 to $55. Is it possible to create a formula to do this?
A cell can either have a value or a formula but not the both.
To change the TC price in the first place, you will need a VBA solution to achieve that.
And if you are open to a VBA solution, please upload a sample file with small subset of your data (after removing any sensitive data) and the layout of your sample file and your original file must be exactly the same.