Hello everyone. I'm new to the forum.

I've created 3 check boxes that are next to three individual names.

Checkbox1 John Doe Percentage%
Checkbox2 Jane Doe Percentage%
Checkbox3 Paul Doe Percentage%

What I want to do is write a formula, that when only one checkbox is checked, then John Doe shows 100%, and the rest 0%. If two are checked then show 55% and 45%. If all three are checked then show 40%, 35%, 25%.

I tried IF statements, and a COUNTIF statement, but I can't seem to get this combination of percentages to work.

How about a comparison formula of some sort?
Any thoughts? Solutions?