To your Conditional Formatting laws, we’re going to attempt to see if the significance within the column B are higher than or equivalent to the complete level of weeks we want to come across. We put one at the conclusion of the newest algorithm (understand the screenshot less than) to account for day “no,” in which there’s absolutely no percentage.
I would also like to be sure the latest anchoring is set up properly: we wish to totally anchor cell C8 since we shall always need certainly to resource one to cell (the entire number of weeks). Continue reading “Switching the fresh new Calculator to own Optional A lot more Repayments”