Good day to all,
I've scoured the internet trying to find a formula that can solve my problem. Alas, I've come up empty handed.
I need to find a way to calculate the total cost based on an annual amount paid per year. If the amounts paid are in column "G" and the year is in column "B" and the fee table per year and amount is as below, what formula can I used??
Table.png
For starters, I have tried the following, which does not account for the year, but I keep getting a zero value.
=SUMPRODUCT(--(G13/$G$1)>$C$5:$C$9;((G13/$G$1)-$C$5:$C$9);$L$5:$L$9)
I've also tried using multiple IF conditions, but that just ends up being too complicated!
Any ideas?
Thanks in advance,
Alma
Bookmarks