ACOS Function in Excel: Angle From a Cosine
ACOS is the inverse of COS. It appears in the formula for distance between two places on Earth.
Read article →Math & Trig
Excel Math & Trig functions explained with syntax, examples and common mistakes.
ASINH Function in Excel: Inverse Hyperbolic Sine
ASINH Function in Excel: Inverse Hyperbolic Sine
Maths & trigLevel: ExpertAvailable in: Excel 2007+ASINH returns the inverse hyperbolic sine.Syntax=ASINH(number)ArgumentWhat it meansnumberValue (angles.
Read article →ACOT Function in Excel: Inverse Cotangent
ACOT Function in Excel: Inverse Cotangent
Maths & trigLevel: ExpertAvailable in: Excel 2013+ACOT returns the angle (0 to π) whose cotangent is x.Syntax=ACOT(number)ArgumentWhat it meansnumberValue.
Read article →ASIN Function in Excel: Angle From a Sine
ASIN Function in Excel: Angle From a Sine
MathLevel: ExpertAvailable in: Excel 2007+ASIN returns the angle (in radians) whose sine is the given number.Syntax=ASIN(number)ArgumentWhat it.
Read article →ATAN2 Function in Excel: Angle From X and Y
ATAN2 Function in Excel: Angle From X and Y
ATAN2 returns the angle of a point, handling all four quadrants. Note Excel’s order is (x, y) — the reverse of many programming languages.
Read article →ATANH Function in Excel: Inverse Hyperbolic Tangent
ATANH Function in Excel: Inverse Hyperbolic Tangent
Maths & trigLevel: ExpertAvailable in: Excel 2007+ATANH returns the inverse hyperbolic tangent (input between -1 and 1).Syntax=ATANH(number)ArgumentWhat.
Read article →COTH Function in Excel: Hyperbolic Cotangent
COTH Function in Excel: Hyperbolic Cotangent
Maths & trigLevel: ExpertAvailable in: Excel 2013+COTH returns 1/TANH(x).Syntax=COTH(number)ArgumentWhat it meansnumberValue (angles in.
Read article →COS Function in Excel: Cosine of an Angle
COS Function in Excel: Cosine of an Angle
COS also expects radians. Seasonal models sometimes use SIN and COS of the month to capture yearly cycles.
Read article →TAN Function in Excel: Tangent of an Angle
TAN Function in Excel: Tangent of an Angle
MathLevel: IntermediateAvailable in: Excel 2007+TAN links an angle to a slope. Radians again — wrap degrees in RADIANS().Syntax=TAN(number)ArgumentWhat it.
Read article →DEGREES Function in Excel: Radians to Degrees
DEGREES Function in Excel: Radians to Degrees
MathLevel: IntermediateAvailable in: Excel 2007+DEGREES converts radians back to degrees.Syntax=DEGREES(angle)ArgumentWhat it meansangleIn.
Read article →SIN Function in Excel: Sine of an Angle
SIN Function in Excel: Sine of an Angle
MathLevel: IntermediateAvailable in: Excel 2007+SIN expects radians. Wrap degrees in RADIANS().Syntax=SIN(number)ArgumentWhat it meansnumberAngle in.
Read article →RADIANS Function in Excel: Degrees to Radians
RADIANS Function in Excel: Degrees to Radians
MathLevel: IntermediateAvailable in: Excel 2007+RADIANS converts degrees, because SIN, COS and TAN in Excel expect.
Read article →