@firemountain7 Yes, replace cell E26 with the following
=IF(F26, IF(C20/12>1615, FLOOR((FLOOR(C20/12)-1615)*0.09)*12,0), "Lucky you :p")
that should do it : )
@mooh Hey! Thanks for such a kind comment : )
Here's the template: https://docs.google.com/spreadsheets/d/1IPopS5NhfnzemcWgDtMruEo0HrqSAQsPBeP1hPA2Ffk/edit?usp=sharing
Let me know if there's a mistake somewhere or if I can change anything for you
@soworriedaboutthis I'm afraid there is no easy answer. Nobody knows the future rates. It WILL be a risk that you have to accept. The decision is up to you.