ACOT Function

Returns the angle whose cotangent is a given number.

Category

Math & Trig

Available in

Excel 2013+, Microsoft 365

Returns

An angle in radians (0 to π)

Want to practice ACOT in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

ACOT reverses COT, returning an angle between 0 and π.

The answer is in radians. Wrap it in DEGREES to get degrees.

Syntax

=ACOT(number) Explain

Arguments

ArgumentRequired?What it does
numberYesThe cotangent of the angle.

Examples

Example 1 — Angles from cotangents

Returned in degrees.

B2fx=DEGREES(ACOT(A2))
AB
1CotangentDegrees
2145
3090
4-1135
=DEGREES(ACOT(A2)) Explain

Common mistakes

  • Text input. Returns #VALUE!.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.