SUMXMY2 Function in Excel: Sum of Squared Differences
Maths & trigLevel: ExpertAvailable in: Excel 2007+SUMXMY2 returns Σ(x - y)²: the squared error between forecasts and actuals.Syntax=SUMXMY2(array_x.
Read article →Math & Trig
Excel Math & Trig functions explained with syntax, examples and common mistakes.
LOG10 Function in Excel: Base-10 Logarithm
LOG10 Function in Excel: Base-10 Logarithm
LOG10 tells you the order of magnitude. Charts of values ranging from hundreds to crores are easier to read on a log scale.
Read article →LOG Function in Excel: Logarithm to Any Base
LOG Function in Excel: Logarithm to Any Base
LOG answers “what power gives this number?” — how many doublings, how many digits.
Read article →LN Function in Excel: Natural Logarithm
LN Function in Excel: Natural Logarithm
LN is the logarithm with base e. Finance uses it for continuously compounded (log) returns.
Read article →ACOSH Function in Excel: Inverse Hyperbolic Cosine
ACOSH Function in Excel: Inverse Hyperbolic Cosine
Maths & trigLevel: ExpertAvailable in: Excel 2007+ACOSH returns the inverse hyperbolic cosine (input 1 or more).Syntax=ACOSH(number)ArgumentWhat it.
Read article →EXP Function in Excel: e Raised to a Power
EXP Function in Excel: e Raised to a Power
EXP returns e^x and undoes LN. Use it to turn summed log returns back into an ordinary percentage.
Read article →SECH Function in Excel: Hyperbolic Secant
SECH Function in Excel: Hyperbolic Secant
Maths & trigLevel: ExpertAvailable in: Excel 2013+SECH returns 1/COSH(x).Syntax=SECH(number)ArgumentWhat it meansnumberValue (angles in.
Read article →COSH Function in Excel: Hyperbolic Cosine
COSH Function in Excel: Hyperbolic Cosine
COSH returns the hyperbolic cosine (e^x + e^-x)/2: the shape of a hanging cable.
Read article →ACOTH Function in Excel: Inverse Hyperbolic Cotangent
ACOTH Function in Excel: Inverse Hyperbolic Cotangent
Maths & trigLevel: ExpertAvailable in: Excel 2013+ACOTH returns the inverse hyperbolic cotangent (|x| > 1).Syntax=ACOTH(number)ArgumentWhat it.
Read article →SINH Function in Excel: Hyperbolic Sine
SINH Function in Excel: Hyperbolic Sine
Maths & trigLevel: ExpertAvailable in: Excel 2007+SINH returns the hyperbolic sine (e^x - e^-x)/2.Syntax=SINH(number)ArgumentWhat it meansnumberValue.
Read article →CSCH Function in Excel: Hyperbolic Cosecant
CSCH Function in Excel: Hyperbolic Cosecant
Maths & trigLevel: ExpertAvailable in: Excel 2013+CSCH returns 1/SINH(x).Syntax=CSCH(number)ArgumentWhat it meansnumberValue (angles in.
Read article →ATAN Function in Excel: Angle From a Slope
ATAN Function in Excel: Angle From a Slope
MathLevel: ExpertAvailable in: Excel 2007+ATAN turns a slope (rise/run) into an angle. ATAN2 handles all four quadrants.Syntax=ATAN(number)ArgumentWhat it.
Read article →