Help with formula cant get it to work... excel spreadsheet attached for reference and test

Hello
I currently have a formula for in column M and im confused why row 15 is calculating 2 payments instead of 9. I do not know what to add in order to fix the issue. Can someone edit my formula so that one formula will work for all cases as far as Column N giving me the correct number of months. It should work for payments that have ended and for future payments. Please help. Thank you

Thanks, Val

Tried to look at it but you are getting external data from another spreadsheet. Could you please upload that one also?

It looks like there is something with your IF statements and how the determining factors play out or what you are multiplying the Montly Payments By...

With the formula the logicon row 15 is going with this.. So let me know where the problem is here and we can help more.

Final Payment (Y) is Greater Than As Of (Y)
DOF (Y) is Less than As Of (Y)
Final Payment (M) IS NOT less than As Of (M)
So it now calculates Monthly Payment * Final Payment (M)

Monthly Payment * Februrary is basically what it's trying to calculate.


Now if the Final Payment (M) is less than As Of (M) then it would be calculating Monthly Payments * (As of Month - DOF)

Administrative Note:

• We would love to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about proper thread title
• Please PM me when complete (Also, include a link to your thread - copy from the adress bar) and this post will be removed which will reset the replies to zero…
  
  To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title

Originally Posted by valeriyklimov

So what exactly would you say the formula should be... what formula would you write?
I need it to calculate payment for the current year that is being calculated not a cumulative of all years.... if you understand what im saying.

Let's see if I have this right... You want to calculate the total payments from January to the current month?

If not, please right it down like you would a regular math problem..


Current Month - January = Amount to multiply payments by.....

@ vamosj...Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc