I don't understand. The formula result says that you need to accumulate $854.17 each month Feb through Dec to reach $10,000 after having $250 for Jan.
This is how I interpreted your request.
Here is a goal seek scenario attached.
Goal Seek is on the Data Tab. What If Analysis
Last edited by alansidman; 05-09-2018 at 11:56 AM.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Got it Alan. Thanks for the Excel example.
Ideally the monthly increases would incrementally increase each month. January would be the lowest amount, February more than January, March more than February and so on until December being the highest number but still totaling 10,000 for the entire year.
Is there anything we can add to your spreadsheet to get those increasing increments?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks