Use the built-in function `=T.TEST(array1,array2,tails,type)` for a t-test p-value
Use `=T.DIST.2T(x,deg_freedom)` for a two-tailed t-distribution p-value
Use `=T.DIST.RT(x,deg_freedom)` for a right-tailed t-distribution p-value
Use `=T.DIST(x,deg_freedom,TRUE)` to get the cumulative left-tail probability
Use `=CHISQ.TEST(actual_range,expected_range)` for a chi-square test p-value
Use `=F.TEST(array1,array2)` for an F-test p-value
Use `=Z.TEST(array,mu,sigma)` for a z-test p-value
Use `=NORM.S.DIST(z,TRUE)` to get the standard normal cumulative probability
Use `=1-NORM.S.DIST(z,TRUE)` for a right-tailed z-test p-value
Use `=2*(1-NORM.S.DIST(ABS(z),TRUE))` for a two-tailed z-test p-value
Use the Data Analysis ToolPak: Data tab > Data Analysis > select the test > read the p-value in the output
Use `=PERCENTRANK.INC(range,x)` only for percentile rank, not p-value
Use `=BINOM.DIST(number_s, trials, probability_s, TRUE)` for a binomial cumulative probability
Use `=1-BINOM.DIST(number_s-1, trials, probability_s, TRUE)` for a right-tailed binomial p-value
Use `=POISSON.DIST(x,mean,TRUE)` for a Poisson cumulative probability
Use `=1-POISSON.DIST(x-1,mean,TRUE)` for a right-tailed Poisson p-value