What kind of formula I must use in E5 when I drag it towards right, it fulfills the conditon
CONDTION
I have a fixed monthly payment, a start date, and a given number of months.
What formula can I use to sum total payments by year.
What kind of formula I must use in E5 when I drag it towards right, it fulfills the conditon
CONDTION
I have a fixed monthly payment, a start date, and a given number of months.
What formula can I use to sum total payments by year.
hi there. here's 1 of the ways:
=IFERROR(DATEDIF(MAX(start,--("1jan"&E4)),MIN(end,--("1jan"&E4+1)),"m")*amount,0)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank you very much sir for your solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks