GAMMAINV Function in Excel: Inverse Gamma (Older Name)
GAMMAINV returns the value at a gamma probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →Excel Functions A–Z
Every Excel function explained with syntax, examples, common errors and powerful combinations — from beginner to expert.
GAMMADIST Function in Excel: Gamma Distribution (Older Name)
GAMMADIST Function in Excel: Gamma Distribution (Older Name)
GAMMADIST returns the gamma probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →WRAPCOLS Function in Excel: Fold a List Into Columns
WRAPCOLS Function in Excel: Fold a List Into Columns
WRAPCOLS takes a long list and wraps it into columns of a fixed height — printable labels, seating plans.
Read article →TTEST Function in Excel: t-Test (Older Name)
TTEST Function in Excel: t-Test (Older Name)
TTEST returns the p-value of a t-test between two samples. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and…
Read article →WRAPROWS Function in Excel: Reshape a List Into a Grid
WRAPROWS Function in Excel: Reshape a List Into a Grid
WRAPROWS reshapes a single column into rows of a fixed width — e.g. a pasted list where every 3 lines are one record.
Read article →ERF.PRECISE Function in Excel: Error Function (2010+ Version)
ERF.PRECISE Function in Excel: Error Function (2010+ Version)
EngineeringLevel: ExpertAvailable in: Excel 2010+ERF.PRECISE is the 2010 version of ERF with one argument.Syntax=ERF.PRECISE(x)ArgumentWhat it.
Read article →GAMMA.INV Function in Excel: Value for a Gamma Probability
GAMMA.INV Function in Excel: Value for a Gamma Probability
StatisticsLevel: ExpertAvailable in: Excel 2010+GAMMA.INV returns the value at a given gamma probability.Syntax=GAMMA.INV(probability, alpha.
Read article →ERFC.PRECISE Function in Excel: Complementary Error Function (2010+ Version)
ERFC.PRECISE Function in Excel: Complementary Error Function (2010+ Version)
EngineeringLevel: ExpertAvailable in: Excel 2010+ERFC.PRECISE is the 2010 version of ERFC.Syntax=ERFC.PRECISE(x)ArgumentWhat it meansxValueExamplesExample.
Read article →BINOM.DIST.RANGE Function in Excel: Probability of Successes in a Range
BINOM.DIST.RANGE Function in Excel: Probability of Successes in a Range
BINOM.DIST.RANGE gives the chance of getting between s and s2 successes in n trials, e.g. 3 to 5 sales from 20 calls.
Read article →GAMMA.DIST Function in Excel: Gamma Distribution
GAMMA.DIST Function in Excel: Gamma Distribution
GAMMA.DIST models waiting times and amounts that are always positive and skewed, like claim sizes or repair times.
Read article →ZTEST Function in Excel: z-Test (Older Name)
ZTEST Function in Excel: z-Test (Older Name)
ZTEST returns the one-tailed p-value of a z-test. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →EXPONDIST Function in Excel: Exponential Distribution (Older Name)
EXPONDIST Function in Excel: Exponential Distribution (Older Name)
EXPONDIST returns the exponential probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →