The CHISQ.DIST function returns the chisquared distribution. The chisquared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.
Syntax:= CHISQ.DIST(x,deg_freedom,cumulative)
The CHISQ.DIST function syntax has the following arguments:
 X The value at which the chisquare distribution is to be evaluated (must be ≥ 0).
 Deg_freedom: The number of degrees of freedom (must be an integer between 1 and 10^{10}).(If the supplied value is a decimal, this is truncated to an integer)

Cumulative A logical argument that specifies the type of chisquare distribution to be calculated. This can be either:
TRUE – Calculate the cumulative distribution function FALSE – Calculate the probability density function
Example: Let’s look at some Excel CHISQ.DIST function examples and explore how to use the CHISQ.DIST function as a worksheet function in Microsoft Excel:
Syntax: =CHISQ.DIST(B1,B2,FALSE)
Result: 0.207553749
Based on the Excel spreadsheet above, the following CHISQ.DIST examples would return:
Syntax: =CHISQ.DIST(C1,C2,TRUE)
Result: 0.520499878
Syntax: =CHISQ.DIST(D1,D2,TRUE)
Result: 0.712702505
Syntax: =CHISQ.DIST(E1,E2,FALSE)
Result: 0.11156508
Note:
 If any argument is nonnumeric, CHISQ.DIST returns the #VALUE! error value.
 If x is negative, CHISQ.DIST returns the #NUM! error value.
 If deg_freedom is not an integer, it is truncated.

If deg_freedom < 1 or deg_freedom > 10^10, CHISQ.DIST returns the #NUM! error value.