=PERMUT(3,2)
The excel formula above will display the number of ordered combinations you can have for 3 items by using 2 items out of 3. Let's say you had the options A, B,and C, which equates to 3 as above. Also, let's say you can take only two options in different orders as sugested by the 2 after the comma. So the formula above will give you 6 as the answer, as there are 6 possible ordered combinations. The following explains the ordered combinations you can have. So out of A, B, and C the 6 possible combinations you can have are: AB, BA, BC,CB, AC and CA.
The excel formula above will display the number of ordered combinations you can have for 3 items by using 2 items out of 3. Let's say you had the options A, B,and C, which equates to 3 as above. Also, let's say you can take only two options in different orders as sugested by the 2 after the comma. So the formula above will give you 6 as the answer, as there are 6 possible ordered combinations. The following explains the ordered combinations you can have. So out of A, B, and C the 6 possible combinations you can have are: AB, BA, BC,CB, AC and CA.
0 comments:
Post a Comment