Goal seeker
Hello.
Quick question about goal seek:
I have the column M, the sum of the column in cell N42, and the criteria for progressive tax, which are (L42:L48):
Under 160k - 0%
160k-210k - 15%
210k-310k - 25%
>= 310k - 33%
As you can see, the sum right now is 630350.
Now i need to make a goal seek, to turn the sum to 900,000, but keep the spread for the criteria (15%, 10%, 8%) the same. I even have the results: (4%, 19%, 29%, 37%), but i need to know how to calculate it myself.
Thanks!!!
So you want to make them add up to 900000 but keep the same spread? I don't really know what is going on on the rest of the sheet to make sense of what numbers you have and how the spread is distributed. Most of the numbers are 32500 what is that?
If someone helped give them rep using the star button.
If you have received a satisfactory solution please mark the thread solved. If not Fotis will come for you at night :P
The 32500 (column M) is the progressive tax which is calculated from the column K, by the formula above (Under 160k - 0%, 160k-210k - 15%, 210k-310k - 25% and above that - 33%).
What I'm asking is how to technically do it? If you do the "goal seek" function, than you can choose only a single cell in the "By changing cell" part, but i need all four cells to adjust (L45-L48).
The formula in B9 is
Please Login or Register to view this content.
=A9 - SUMPRODUCT((A9>A3:A6)*(A9-A3:A6)*(B3:B6-B2:B5))
Use GoalSeek to set B9 to 900,000 by changing A9
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks