Excel like a finance pro.
← The libraryPractice · 2 questions →
Math function
ACOT
Returns the arccotangent of a number, in radians.
Rarely usedDifficulty 1350 · AdvancedUsage rank #314 of 520
When to use it
Inverse cotangent, in radians between 0 and pi.
The shape of it
- Syntax
=ACOT(number)
Worked examples
One
=ACOT(1) → 0.785398163
Pi over four.
In degrees
=DEGREES(ACOT(1)) → 45
In degrees.
Zero
=ACOT(0) → 1.570796327
Pi over two.
Worth knowing
- ACOT(x) = ATAN(1/x) for positive x.
- Rarely needed in finance; ATAN covers most cases.
- Convert with DEGREES to read the result.
Where it goes wrong
- Returns radians.
- Negative inputs give angles between pi/2 and pi, not negative angles.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.