Annual payments based on varying monthly payments

stegasnorus

New member
Joined
Aug 8, 2018
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2010
Hi All!

Starting Sept. 1, 1970, I purchased an apple every month, and the price goes up by one dollar every 10th September from that point on. I'm trying to populate an annual payments column where the anniversary of payments is every March. I was hoping that one of you gurus might be able to help me find a formula to populate this column? Please find an image of my problem attached, and note that I need formulas to get the values in the "$Spent on Apples in year" column.

PleaseHelpMeWithExcelImage.PNG

Thanks!
 
Back
Top