A review of all Excel formula syntaxes, as in what each formula needs to work
Correct Syntax for the "=RAND" Function
=RAND()
Correct Syntax for the "=NORM.DIST" Function
=NORM.DIST(Upper limit ,mean ,STD, TRUE), or =NORM.DIST(Lower limit ,mean ,STD, TRUE)
Correct Syntax for the "=COUNT" Function
=COUNT(Range)
Correct Syntax for the "=CONFIDENCE.NORM" Function
=CONFIDENCE.NORM(Alpha, STD, Sample Size)
Correct Syntax for the "=COUNTIF" Function
=COUNTIF(Range)
Correct Syntax for the "=COUNTA" Function
=COUNTA(Range)
Correct Syntax for the "=NORM.S.INV" Function
=NORM.S.INV(Probability) -> (1-Level of Sig / 2)
Correct Syntax for the "=NORM.S.DIST" Function
=NORM.S.DIST(Test Statistic, TRUE)
Correct Syntax for the "=SQRT" Function
=SQRT(Number)
Correct Syntax for the "=MIN" Function
=MIN(Number)
Correct Syntax for the "=T.DIST" Function
=T.DIST(Test Statistic, Degrees of Freedom, TRUE)
Correct Syntax for the "=T.INV.2T" Function
=T.INV.2T(Level of Sig., Degrees of Freedom)
Correct Syntax for the "=STDEV.S" Function
=STDEV.S(Range)
Correct Syntax for the "=VAR.S" Function
=VAR.S(Range)
Correct Syntax for the "=MEDIAN" Function
=MEDIAN(Range)
Correct Syntax for the "=AVERAGE" Function
=AVERAGE(Range)