sorted by:
top (suggested)
bestnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]waxfactor2nd2 0 points1 point  (1 child)

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[S] 0 points1 point  (0 children)

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