ACOT in Zoho Sheet: Inverse Cotangent and Angle Calculations

• Introduced: The original introduction version and date are not established by the checked sources.
• Availability: Currently documented in Zoho Sheet’s rolling web-service help; no numbered release or retirement endpoint is established.
• Scope: English-language web-service documentation. Mobile and offline-client parity is outside the verified scope.
• Checked: October 14, 2026, against the official ACOT reference. Documentation check; not a new native test.

=ACOT(number)

Zoho’s official ACOT reference documents exactly one argument, no optional mode, and a radian result in the 0-to-π principal range. Its published examples include =ACOT(-1.3) → 2.485897027, =ACOT(4) → 0.244978663, and =ACOT(1/2) → 1.107148718. These are documentation-reported outputs, not measurements from our own Zoho workbook.

number is already a ratio, not an angle. Passing 30 does not ask for 30 degrees. Use =RADIANS(30) when converting 30° to radians, or =DEGREES(ACOT(B2)) when converting an inverse-cotangent result back to degrees.

Why the sign changes the angle: Cotangent equals cosine divided by sine. On the interval (0°,180°), sine is positive, so the sign of cotangent follows cosine: positive for acute angles, zero for 90°, and negative for obtuse angles. This is why ACOT(-1) should be 135° under Zoho’s documented 0-to-π convention—not −45°.

Enter the input values below in B2:B9. In E2, enter =ACOT(B2) to obtain radians; in F2 enter =DEGREES(ACOT(B2)) to obtain degrees. Fill both formulas through row 9.

The expected numbers were computed independently with the mathematical reference atan2(1,x) (which selects an angle in (0,π) for finite x). They have not been calculated in Zoho Sheet. Each displayed angle was also checked by substituting it back into cos(angle)/sin(angle) and comparing with the original ratio within a numerical tolerance.

Step-by-step check: (1) Enter the example values in a new sheet. (2) Confirm that B2 is numeric -4, not text '-4'. (3) Type the single-cell formula =ACOT(B2) in E2 and fill downward. (4) Type the degree-conversion formula in F2 and fill downward. (5) Set F to a numeric format with six decimal places. (6) Compare the 90° midpoint at row 6 and the 135° result for B4=-1. These are especially useful checks for negative-branch mistakes and accidental degree/radian confusion.

Suppose a technician measures an adjacent leg of 12 cm and an opposite leg of 5 cm in a right triangle. Put adjacent distance in C2 (12) and opposite distance in D2 (5). The adjacent-to-opposite ratio is 12/5 = 2.4. To calculate the acute angle opposite the 5-cm side, use:

=DEGREES(ACOT(C2/D2))

Independent mathematics gives 22.61986495° (rounded to 22.619865°). This is an especially convenient expression when a report supplies run divided by rise rather than the rise divided by run expected by ATAN. For a right triangle with both legs positive, =DEGREES(ATAN(D2/C2)) gives the same acute angle, provided C2 is nonzero.

If the adjacent displacement is negative but the opposite displacement is positive, such as C2=-12, D2=5, the same cotangent ratio is negative and Zoho’s principal ACOT branch yields an obtuse 157.380135°. This can be useful for an oriented half-plane calculation, but do not interpret it as a full navigation bearing: if the opposite component also changes sign, the ratio alone does not tell you which of two directions to choose.

Check the geometry before dividing

When an opposite leg can be zero, C2/D2 is undefined. A simple guard for numeric, signed components is:

=IF(D2=0;"CHECK OPPOSITE";DEGREES(ACOT(C2/D2)))

For C2=12,D2=5 the expected numeric result is 22.619865; for D2=0 the intended output is the text CHECK OPPOSITE. This is an illustrative combined Zoho-style formula, not natively executed; confirm argument separators and number types in your Zoho locale. A numeric zero in the ratio itself, by contrast, is valid and means 90°. Those two situations are not interchangeable.

For a signed vector (x,y) with arbitrary quadrant, prefer the documented ATAN2(x;y) design and separately confirm its origin case and target argument order. Reconstructing an angle from x/y destroys the signs of both components whenever they change together. ACOT remains useful when the ratio and chosen principal interval are exactly what the problem calls for.

Zoho’s help article also lists generic #N/A! and #REF! cases. That list is not evidence that a simple numeric ACOT call causes all these errors. Deleted cell references can produce #REF! upstream; lookup errors can propagate from another cell. The precise handling of blanks, numeric text, infinity-like imports, and negative zero remains unverified by native Zoho testing.

Excel comparison: Microsoft’s ACOT documentation independently confirms one real-number argument and the same 0-to-π principal interval. This supports a conceptual formula comparison, not an assertion of identical text coercion, rounding precision or behavior across releases. Google Sheets caution: Google’s ACOT help has a contradiction: its prose says 0..π, yet its example displays ACOT(-4) as −0.2449786631, unlike Zoho’s published positive obtuse result for a negative value. Treat that as a documentation/migration issue needing direct native tests, rather than silently equating the two engines.

• Zoho primary: ACOT—official Zoho Sheet Help, directly checked 2026-10-11. Confirmed syntax, result interval, three vendor examples and generic error guidance.
• Cross-software primary: ACOT—Microsoft Excel Support, directly checked 2026-10-11; ACOT—Google Docs Editors Help, directly checked 2026-10-11. Their content is not a native Zoho experiment.
• Validation: Eight reference rows were evaluated using Python math.atan2, with independent trigonometric round-trip checks; native Zoho Sheet executions: 0. CSV import/formatting, locale separators, error strings and full desktop/mobile behavior remain untested. No first-supported version, account rollout or cross-platform parity is asserted.