• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Excel help! Need help creating a formula

C

CoRPS

[H]ard|Gawd
Joined
Feb 19, 2004
Messages
1,389
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?
 
You must log in or register to reply here.
Back
Top