मंगलवार, 21 जून 2022

Learn how to use combin formula in Excel step by step.

COMBIN

combine cells in excel

What Does It Do ?
This function calculates the highest number of combinations available based upon
a fixed number of items.
The internal order of the combination does not matter, so AB is the  same as BA.

Syntax
 =COMBIN(HowManyItems,GroupSize)

Formatting
No special formatting is required.

Example 1
This example calculates the possible number of pairs of letters available
from the four characters ABCD.
combine two columns in excel

Example 2
A decorator is asked to design a colour scheme for a new office.
The decorator is given five colours to work with, but can only use three in any scheme.
How many colours schemes can be created ?
excel combine cells

कोई टिप्पणी नहीं:

एक टिप्पणी भेजें