Cell stays the same if condition is true, regardless of factor changes

[Tricks]

So I have a page designed to help me pay large sums of money back to someone by giving them a percentage of what I earn each week. The parts I am concerned with look roughly like this:

Self Input
Title
Formula

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"]% to pay each week:[/TD]
[TD]10%[/TD]
[/TR]
[TR]
[TD]Week Total[/TD]
[TD]Amount to pay[/TD]
[TD]Paid?[/TD]
[/TR]
[TR]
[TD]$100[/TD]
[TD]$10 (A3*C$1$)[/TD]
[TD]Paid[/TD]
[/TR]
[TR]
[TD]$100[/TD]
[TD]$10 (A4*C$1$)[/TD]
[TD]Paid[/TD]
[/TR]
[TR]
[TD]$100[/TD]
[TD]$10 (A5*C$1$)[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]








Once I have written "paid" into the cell it subtracted the "amount to pay" from the amount that I owe the person.

What I would like to do is at any point change the "% to pay each week" without it altering any "Amount to pay" that has "paid" written next to it. So that if in the previous table I was to change the 10% to 20% it would look like this:


[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"]

% to pay each week:​

[/TD]
[TD]20%[/TD]
[/TR]
[TR]
[TD]Week Total[/TD]
[TD]Amount to pay[/TD]
[TD]Paid?[/TD]
[/TR]
[TR]
[TD]$100[/TD]
[TD]$10[/TD]
[TD]Paid[/TD]
[/TR]
[TR]
[TD]$100[/TD]
[TD]$10[/TD]
[TD]Paid[/TD]
[/TR]
[TR]
[TD]$100[/TD]
[TD]$20 (A5*C$1$)[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]








Is this at all possible without having to delete the formula's already in the column and replacing them with what I want them to stay as?

Thanks for any help

 

[JoeMo]

Those previous values where "paid" is present must be converted from formulas to values, either by manually selecting them then Copy>Pastespecial Values, or if you are willing to use macros a change event could be coded to automatically convert the formulas to values when you enter "paid" in column C.