I need a formula to calculate a persons share of an arbitrary number, say 1000 based on two variables. The first variable will be the number of hours a person worked. The second variable will be a number between 1 and 10. This will be a number used to determine a persons weight of the profit share. For example, someone with a 4 would end up with the same share as someone else with a 4, providing they both had the same amount of hours. A person with a 4 would have twice the size share as someone with a 2.
This formula would need to work for any number of people, from 1 to 100.
This is important! The total shares for everyone would need to add up to the total amount, 1000 in this case.