![[H]ard|Forum](/styles/hardforum/xenforo/logo_dark.png){kind=logo}
A friend of mine is setting up a company and wants me to do an excel sheet for him. I took on the responsibility but now I'm stumped.
Basically there's three people. And for each job they get a certain percentage based on who was present or not. If 1 person was present they get 60% while the other 2 get 20% each. If 2 people were present the 2 present get 40% and the absent partner gets 20%. If all three are present they get 1/3 (33.3333%) each.
I have absolutely no idea how to set this up. Any help?
Basically there's three people. And for each job they get a certain percentage based on who was present or not. If 1 person was present they get 60% while the other 2 get 20% each. If 2 people were present the 2 present get 40% and the absent partner gets 20%. If all three are present they get 1/3 (33.3333%) each.
I have absolutely no idea how to set this up. Any help?