Author: Oscar Cronquist Article last updated on May 11, 2022

The CHISQ.DIST.RT function was introduced in Excel 2010 and calculates the right-tailed probability of the chi-squared distribution. It has replaced the CHIDIST function and RT in the function name stands for right-tailed.

Formula in cell C6:


Excel Function Syntax



x Required. A numerical value representing a point in the probability distribution you want to be evaluated.
deg_freedom Required. A numerical value representing the degrees of freedom.


The CHISQ.DIST.RT function returns

  • #VALUE! error value if x or deg_freedom argument is non-numeric.
  • #NUM! error value if:
    • < 0 (zero)
    • deg_freedom  < 1
    • deg_freedom  > 10^10

deg_freedom argument is converted into integers.