Practice free

ACOT function

ACOT returns the angle, in radians, whose cotangent is the number you give it. The result falls between 0 and PI, so a negative input gives an answer above half of PI.

Example

Read it as a sentence: find the angle, in radians, whose cotangent is 1.

Practice this in the app

Syntax

ACOT(number)

number (required)
Any real number.

Returns: The angle in radians, between 0 and PI.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=ACOT(0.5) 1.107148718 Positive
=ACOT(0) 1.570796327 Zero
=ACOT(-0.5) 2.034443936 Negative
=ACOT(2) 0.463647609 Larger value
=ACOT("0.5") 1.107148718 Text number "0.5"
=ACOT(TRUE) 0.785398163 TRUE
=ACOT("abc") #VALUE! Non-numeric text
=ACOT(Data!E4) #DIV/0! Error cell propagates

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • Result is between 0 and PI, so ACOT of a negative number is above PI/2.

Where it works

Excel
ACOT arrived in Excel 2013. Older versions do not have it.
Google Sheets
Same name, same behaviour for everyday use.

Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .