Forum Discussion
How to use logical condiiton
Thanks for the reply. requires more help.
The percentage in C24 remains static. If we increase or decrease expense the percentage (in C24)should change accordingly and balance column should not go negative
BABA1978 Perhaps you can start by explaining the logic for the changes in C. Currently, the uplifts are hardcoded in every cell and are far from static (starting with 3.5, then 9.9 in month 12, thereafter 3.6 but then in month 21 it goes down to 3.5 again. Then 9.5 in month 24 and then 5.9 from month 25 onwards etc. etc. Could it be that you simply forgot to change the factors for months 21 through 23?
In the expense column you have amounts with a note every 12th month that mentions an uplift for inflation by 5% (plus 60K for each 12th month).
If you want to automate anything, it's important that you clearly define the rules for it first. These can probably be structured in a table that allows you to pick-up the correct percentages, inflation adjustments and yearly extra expenses. Just guessing though.