Your question, your audience. Choose who sees your identity—and your question—with question security.
Solved
Excel help (using macros)
Posted on 2016-09-13
I have the following problem I'd like to compute in a cell.
Payments start at month X (Mar). They go up increments of 10, every 2 months (payment period) for a number of periods 5, until they stop going up and remain at the same level. I want to create cells with the values under "payments" below, i.e. 0, 0, 100, 100, 110, 110, ... 140, 140, 140, 140 etc.
Payment period: Every 2 months.
Number of periods: 5
Start date: Mar
Payment increment amount: 10
Initial payment: 100
Period: 1 2 3 4 5 6
Month: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb
Payment: 0 0 100 100 110 110 120 120 130 130 140 140 140 140
Payments start at month X (Mar). They go up increments of 10, every 2 months (payment period) for a number of periods 5, until they stop going up and remain at the same level. I want to create cells with the values under "payments" below, i.e. 0, 0, 100, 100, 110, 110, ... 140, 140, 140, 140 etc.
Payment period: Every 2 months.
Number of periods: 5
Start date: Mar
Payment increment amount: 10
Initial payment: 100
Period: 1 2 3 4 5 6
Month: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb
Payment: 0 0 100 100 110 110 120 120 130 130 140 140 140 140
2
4 Comments
Active today
Not sure why you want to use macros, this can be done with formulas.
See attached workbook.
Payments.xlsx
See attached workbook.
Payments.xlsx
Thanks very much. I knew it could be done with a formula but frankly was a little stumped. I thought I had a good grasp of excel but your formulas are really elegant and they will be useful for the future. Thanks so much your prompt reply, I now have a very very effective financial model!
Active today
If you are happy with the solution, please do not forget to close the question.
Should you need any explanation of elements of the formula, please let me know.
Thanks
Rob
Should you need any explanation of elements of the formula, please let me know.
Thanks
Rob
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I have recommended this question be closed as follows:
Accept: Rob Henson (https:#a41797614)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
frankhelk
Experts-Exchange Cleanup Volunteer
I have recommended this question be closed as follows:
Accept: Rob Henson (https:#a41797614)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
frankhelk
Experts-Exchange Cleanup Volunteer
Featured Post
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016.
But that just resulted in getting an error message 'Unknown Error'...
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
Suggested Courses
Course of the Month5 days, 16 hours left to enroll
569 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.