Need advice

[suciulaurentiu]

There are 4 methods of payment: annualy, quarterly, semestrial and monthly. For all of these methods we calculate a number of installments (to pay) by the end-user.
First 3 years are presented like in the picture.
Starting with the 4th year, the promotional plan is no longer valid, so the rest of the payment plan is like the annual one.

Please help me out and advice me how can i calculate the whole payment plan payment plan.jpg

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

---

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

[suciulaurentiu]

I have just filled in the date, i wasn`t aware of these instructions on this forum. Thank you for the tip! Maybe you could help me out a little with this calculation, my work depends on it and i`ve been strugling two weeks now...unfortunately.

Basicly i need that starting from the first rate from the 4th year, the calculation is the same as the (normal one). First three years are on (promotional formula)
How can i insert a function which allows me to change the used formula, starting from the 4th year, to give another formula ( there are 4 ways of payment as in the picture- so the first rate in the 4th year can be in rates 3,7,17,37).

Thank you, kind regards