The CHISQ.INV function returns the inverse of the lefttailed probability of the chisquared distribution. The chisquared distribution is commonly used to study variation in the percentage of something across samples.
Syntax:= CHISQ.INV(probability,deg_freedom)
The CHISQ.INV function syntax has the following arguments:
 Probability (required argument) – This is the probability associated with the chisquared distribution.
 Deg_freedom (required argument) – This is the number of degrees of freedom. It must be an integer between 1 and 10^{10}.
Example: Let’s look at some Excel CHISQ.INV function examples and explore how to use the CHISQ.INV function as a worksheet function in Microsoft Excel:
Syntax: =CHISQ.INV(B1,B2)
Result: 3.218875825
Based on the Excel spreadsheet above, the following CHISQ.INV examples would return:
Syntax: =CHISQ.INV(C1,C2)
Result: 1.832581464
Syntax: =CHISQ.INV(D1,D2)
Result: 0.713349888
Syntax: =CHISQ.INV(E1,E2)
Result: 1.323303697
Note:
 If argument is nonnumeric, CHISQ.INV returns the #VALUE! error value.
 If probability < 0 or probability > 1, CHISQ.INV 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.INV returns the #NUM! error value.