Four people are available for the evening desk. You need someone on dispatch, someone on radio and someone on notes. Each person can fill only one role.

In B2, enter 4. In C2, enter 3. In D2, use =PERMUT(B2,C2) and expect 24. There are four choices for the first role, three left for the second and two left for the third.

Three role slots show four choices for Dispatch, then three for Radio, then two for Notes.

Example count. Remove each assigned person before filling the next role.

Ada on dispatch and Eli on radio is a different assignment from Eli on dispatch and Ada on radio, even if both rosters put Ren on notes.

Two valid rosters use the same people but swap Dispatch and Radio.

Example distinction. A different role assignment counts separately.

If dispatch is already assigned to one person, count only the remaining roles and eligible people. If only some people may fill a particular role, calculate from those eligibility rules instead of using the unrestricted result.

Microsoft’s PERMUT reference.