Contact
12 programs
Explore the site

ACOS in Zoho Sheet: Calculate Angles from Cosine Ratios

Mathematical Intermediate Zoho Sheet

Use the Zoho Sheet ACOS function to turn a cosine ratio into an angle, convert radians to degrees, and avoid quadrant and input-domain errors.

Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Zoho Sheet. How formula examples are checked

Quick answer: =DEGREES(ACOS(0.5)) gives 60°. Zoho Sheet’s ACOS (inverse cosine or arccosine) takes a cosine value between −1 and 1, and returns the corresponding principal angle in radians, from 0 through Ï€. Wrap it with DEGREES when you need degrees instead of radians.

Unlike COS, which begins with an angle and returns a ratio, ACOS begins with a ratio and returns an angle. This distinction is practical in geometry, measurements, directional analysis and dot products. An ACOS result is not automatically a bearing or a complete 0–360° orientation: it gives only the principal angle. When direction or quadrant matters, preserve the coordinate signs and consider ATAN2 instead.

Official syntax and required argument

=ACOS(number)
Argument Required? Meaning
number Yes Numeric cosine value between −1 and +1, inclusive. May be a literal such as 0.5, a cell reference such as B2, or a numeric expression such as 3/5.

Zoho’s ACOS documentation gives =ACOS(0.3) → approximately 1.266103673 radians, =ACOS(-0.9) → 2.690565842, and =ACOS(1/2) → 1.047197551. The documented result range is 0 ≤ angle ≤ Ï€. The official article also recommends DEGREES or multiplying by 180/PI() for degree measurements.

For a one-argument function, there is no argument separator to confuse. In combined Zoho formulas requiring multiple arguments, examples in its function references often use semicolons; formulas imported from English-language Excel examples may require separator adjustment. This guide’s one-argument examples work without making a general claim about every localization.

Eight-row practice sheet: cosine values into degrees

Enter the cosine values below in column B. The rows include both endpoints of the legal ACOS interval. Enter =ACOS(B2) in E2 and =DEGREES(ACOS(B2)) in F2, then fill both formulas through row 9. These expected numbers were calculated independently with Python’s math.acos and math.degrees, not recorded from a native Zoho Sheet execution.

Row B: cosine ratio =ACOS(Bn) expected radians =DEGREES(ACOS(Bn)) expected degrees
2 -1.00 3.141592654 180.000000
3 -0.75 2.418858406 138.590378
4 -0.50 2.094395102 120.000000
5 0.00 1.570796327 90.000000
6 0.25 1.318116072 75.522488
7 0.50 1.047197551 60.000000
8 0.75 0.722734248 41.409622
9 1.00 0.000000000 0.000000

Reproduce the example: (1) Enter the table, checking that B2:B9 are numeric. (2) Put =ACOS(B2) in a blank result column. (3) Fill down to row 9. (4) Put =DEGREES(ACOS(B2)) beside it and fill down. (5) Format radians and degrees to six or nine decimals as appropriate. (6) Compare the displayed values with the table above. A value printed as 0 or 180 is a rounded representation; precision depends on format and calculation engine.

If you enter =ACOS(0.5) and see 1.047197551, that is not 1.047 degrees. It is radians. Use the nested conversion to see 60 degrees. Conversely, =COS(RADIANS(60)) is expected to return approximately 0.5; the result of COS is a ratio, not an angle.

Advanced use: included angle between two measured vectors

For two nonzero 2-D vectors u = (ux, uy) and v = (vx, vy), the angle between them is defined using the dot product:

cos(theta) = (ux*vx + uy*vy) / (SQRT(ux^2+uy^2) * SQRT(vx^2+vy^2))

In a sheet with ux in A2, uy in B2, vx in C2 and vy in D2, the following illustrative mathematical expression returns the included angle in degrees:

=DEGREES(ACOS((A2*C2+B2*D2)/(SQRT(A2^2+B2^2)*SQRT(C2^2+D2^2))))

For u=(3,4), v=(5,0), the dot product is 15 and the lengths are 5 and 5, giving a ratio of 15/25=0.6. The expected included angle is 53.130102°. This is useful for comparing planned versus measured motion, sketch geometry or comparing a direction to a reference axis. It is not a compass heading: ACOS deliberately omits rotation direction.

Check both vector lengths first. A zero-length vector makes the denominator zero, so an included angle is not defined. If input values are generated by numerical approximations, roundoff can sometimes produce a calculated ratio slightly over +1 or below −1. Such a ratio violates ACOS’s documented domain even when the ideal mathematical ratio should be legal. For a workflow with a justified tolerance, clamp after checking vector lengths:

=DEGREES(ACOS(MAX(-1;MIN(1;(A2*C2+B2*D2)/(SQRT(A2^2+B2^2)*SQRT(C2^2+D2^2))))))

Clamping is not a substitute for diagnosing genuinely incorrect or out-of-range input. Its usefulness is limited to credible floating-point rounding around the mathematically valid bounds. The multi-argument formula shown uses the semicolon style found in Zoho’s published examples; native execution of this combined example is still pending.

Mistakes and edge cases

Symptom What it means and what to check
#NUM! Zoho documents this for number outside −1 through +1. For example, =ACOS(1.1) is invalid; never interpret 1.1 as 110%.
#VALUE! The Zoho error list includes invalid argument data types. Check imported text values, spaces and whether numeric cells are actually text.
#NAME! Check spelling of ACOS, DEGREES, COS, PI and any named ranges.
#REF! A referenced input was deleted or became invalid. Inspect the specific cell reference.
Angle is the wrong unit ACOS outputs radians, not degrees. Add DEGREES(...) or multiply by 180/PI().
Result never exceeds 180° ACOS returns a principal angle from 0 to 180°. Use two signed coordinates and ATAN2 for full-circle direction.
Undefined vector angle One of the vectors has length 0; ACOS alone cannot fix division by zero.
A ratio near 1 fails Verify actual data first. Only justified floating-point drift should be clamped.

Important distinction: =ACOS(-0.5) returns about 2.094395102 radians, equivalent to 120°, not −60°. Cosine is even, so angles of opposite sign can share the same cosine. Reconstructing the original full-turn orientation from a cosine ratio alone is impossible. A single 120° included angle does not tell you clockwise versus counterclockwise rotation.

ACOS versus nearby functions and other spreadsheets

Function Input → output When to use
COS(angle) Radian angle → cosine ratio Calculate a component or dot-product ratio from a known angle.
ACOS(ratio) Cosine ratio → angle 0..π radians Find an unsigned included angle.
ASIN(ratio) Sine ratio → angle −π/2..π/2 radians Find signed elevation in the principal interval.
ATAN2(x;y) Two signed coordinates → angle Preserve quadrant information for a polar direction; verify origin edge cases.
DEGREES(angle) Radians → degrees Present a conventional angle measurement.

Microsoft’s Excel ACOS reference documents the same basic mathematical domain and output range. Google Sheets’ function reference also lists ACOS. Matching syntax does not prove identical handling of nonnumeric values, near-boundary floating-point results, locales, or platform rollout. Excel and Google Sheets use the familiar mathematical definition, but software-specific behavior must be independently validated when porting an operational workbook.

Availability: As of the 2026-10-11 documentation check, the official Zoho help article documents ACOS for Zoho Sheet. It does not establish the first supported Zoho release, exact historical mobile-platform support, or entitlement-specific restrictions. Those details are unknown, not inferred from Excel’s release list.

Sources and check date: Zoho ACOS (checked 2026-10-11); Zoho COS (related); Excel ACOS (checked 2026-10-11); Google Sheets list (checked 2026-10-11).

Validation disclosure: Vendor syntax and documented domain were researched. Example numbers and vector arithmetic were independently evaluated in Python; no formula was executed inside native Zoho Sheet, and no genuine Zoho screenshot was captured.