Practice free

COT function

COT returns the cotangent of an angle in radians, which is 1 divided by the tangent. An angle of 0 returns a #DIV/0! error because the tangent is zero there.

Example

Read it as a sentence: find the cotangent of 1 radian.

Practice this in the app

Syntax

COT(number)

number (required)
An angle in radians. Must not be zero.

Returns: The cotangent (1 divided by the tangent).

What Excel actually returns

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

FormulaExcel showsCase
=COT(0.5) 1.830487722 Positive
=COT(-0.5) -1.830487722 Negative
=COT(2) -0.457657554 Larger value
=COT("0.5") 1.830487722 Text number "0.5"
=COT(TRUE) 0.642092616 TRUE
=COT({0.1,0.2}) 9.966644423 Array constant spills
=COT(0) #DIV/0! Zero
=COT("abc") #VALUE! Non-numeric text

Watch out for

Where it works

Excel
COT 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 .