ACOTfunction returns the inverse cotangent (arccot) of a number in radians. It is the opposite of the
COTfunction, which takes an angle and returns its cotangent. The function is used in trigonometry to find the angle whose cotangent is a given number.
- How to use
- Examples of using
ACOTformula not working?
- Similar formulas to
ACOT formula with the syntax shown below, it has 1 required parameter:
- value (required):
The numerical value for which to calculate the inverse cotangent. Must be a real number.
ExamplesHere are a few example use cases that explain how to use the
ACOTformula 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.
ACOTnot working? Here are some common mistakes people make when using the
ACOTGoogle 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.
The following functions are similar to
ACOT or are often used with it in a formula:
COTfunction 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.
ATANfunction 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.
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.
ACOSfunction 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.
You can learn more about the
ACOT Google Sheets function on Google Support.