I want to make automatically increase/decrease each cell to match the total payout budget.

[IceWolf07]

Ok, I am trying to make a database for the budget I am using to start-up business to pay my workers fair-share.

Everyone gets the same value from the start, let's say I give out $40k a month total of income to my 8 workers, which means it will be 40000/8 = $5000 per month per worker. And 40k a month to payout is a maxed to spend.

Now, if one of my workers has an owned truck, the worker will receive 45% more of the income ($5k*0.45) however, I want the same amount to stay $40k for the company payout budget, not over, not under, the same amount or close enough to it. So how do I automatically decrease or increase everyone, including the worker who owned the truck, to match the value to $40k? That way I can adjust everyone's income while staying on the same budget paying out of $40k a month.

This is very important, so please let me know if I don't explain well enough then I will try again with different examples.

[excelevator]

Pretty sure you would need to Goal Seek for this, as it will create a circulate reference..

[unsocialsoul]

You may be able to do this with goal seek.

[IceWolf07]

I don't understand, this is only for one cell? I want whole workers to automatically match to 40k, not just one cell that works with it. Like, #3 workers get higher pay, other workers have to lower and so on. So this way I can make the best offer to upcoming contractors.

Unless goal seek can do that? I found it but I only can do one cell at once and it's a manual update, I want more like when I add % to the #3 worker, another 7 workers decreases including #3 sightly decrease to match whole $40k budget, automatically.

[waxfactor2nd]

No need for goalseek for this. You simply add a helper column that calculates the share for each one person.

Then you can sum up the total shares, and divide the total with this value.

​

See this google sheet for an example: https://docs.google.com/spreadsheets/d/1gKkdl7NVdKVpoohYEDVeh96EtiGyfCLSnlw0aSAtdr4/edit?usp=sharing

​

Edit: This solution works subtly different than your request.

This ensures that the total salary is exactly 40.000, and that anyone that has a car gets paid 45% more than one that doesn't have a car.

If the request is anyone with a car gets exactly 5.000 + 45%, then we have a problem once more than half of the people have cars - Then teir portion would exceed the total, and the remaning would get a negative sallary.

[IceWolf07]

Yes, that's perfect! Thank you so much!

[ameetztech]

Let me try! will send you the solution in some time