Check Sheet Logo
Check Sheet

ACOT

The ACOT function returns the inverse cotangent (arccot) of a number in radians. It is the opposite of the COT function, which takes an angle and returns its cotangent. The function is used in trigonometry to find the angle whose cotangent is a given number.

Usage

Use the ACOT formula with the syntax shown below, it has 1 required parameter:

=ACOT(value)
Parameters:
  1. value (required):
    The numerical value for which to calculate the inverse cotangent. Must be a real number.

Examples

Here are a few example use cases that explain how to use the ACOT formula in Google Sheets.

Calculate the angle from a cotangent value

Given the cotangent of an angle, use the ACOT function to find the angle in radians.

Calculate the phase angle in an AC circuit

In alternating current (AC) circuits, the phase angle is the difference between the voltage and current waveforms. Use the ACOT function to calculate the phase angle of a circuit.

Calculate the bearing angle between two points

When given the coordinates of two points on a map, use the ACOT function to calculate the bearing angle between them. This can help with navigation or calculating distances.

Common Mistakes

ACOT not working? Here are some common mistakes people make when using the ACOT Google Sheets Formula:

Using a non-numeric argument

The ACOT function only accepts numeric arguments. If you provide a non-numeric argument, such as text or a cell containing text, the function will return a #VALUE! error.

Providing a value outside the domain of the function

The domain of the ACOT function is (-∞,-1) U (1,∞). If you provide a value outside this range, the function will return a #NUM! error.

Related Formulas

The following functions are similar to ACOT or are often used with it in a formula:

  • COT

    The COT function returns the cotangent of an angle specified in radians. The cotangent is the ratio of the adjacent side of a right-angled triangle to the opposite side, and is the reciprocal of the tangent.

  • ATAN

    The ATAN function returns the arctangent of a value in radians, which is the angle whose tangent is a given value. This function is commonly used in trigonometry and geometry to calculate angles. The returned angle is in the range -π/2 to π/2.

  • ASIN

    The ASIN function returns the arcsine of a value in radians, which is the angle whose sine is the specified value. This function is commonly used in trigonometry and geometry calculations. When used in a formula, the ASIN function takes a single argument, the value for which to calculate the arcsine.

  • ACOS

    The ACOS function returns the arccosine of a value, which is the angle in radians whose cosine is the specified value. The function is often used in trigonometry to find the angle of a right triangle given the adjacent and hypotenuse. The value parameter must be a number between -1 and 1.

Learn More

You can learn more about the ACOT Google Sheets function on Google Support.