Changing the brand new Calculator for Recommended Even more Money
Towards Conditional Format laws, we are going to try to find out if the importance inside line B was greater than otherwise equal to the entire number of days we should find. I add one at the end of the new algorithm (understand the screenshot below) so you’re able to account for day “zero,” in which there’s no commission.
I would also like to be sure the new anchoring is initiated properly: we want to completely anchor phone C8 as the we shall always want to source you to definitely telephone (the entire quantity of weeks). However, we would like to point column B because you to definitely column includes the new times amount used to determine the attention and you will principal payments.
Generally, the new Conditional Formatting the newest laws says in the event the any during the line B was more than otherwise equal to the full number of days inside cell C8 (plus 1 to account for times “zero”), up coming we want to change the font colour in order to light therefore which effectively “hides” the prices and you will computations in those cells. (more…)