ACOS returns the arccosine of a number, which is the angle whose cosine is that number, expressed in radians. Use it to turn a cosine ratio back into an angle for geometry, engineering, or business calculations.
=ACOS(number)What does ACOS do?
The ACOS function in Excel calculates the arccosine of a number. In plain terms, if you know the cosine of an angle, ACOS tells you what that angle is. The result is always in radians, between 0 and pi, and the input number must be between -1 and 1. This is the inverse of the COS function, so =ACOS(COS(0.5)) returns 0.5.
Why does this matter in a spreadsheet? Many real-world calculations give you a ratio rather than an angle. For example, you might know the horizontal distance and the direct distance to a point, giving you a cosine value. ACOS converts that ratio into a usable angle for design, navigation, quality checks, or reporting. It saves you from manually looking up inverse cosine tables or switching to a scientific calculator.
Imagine you work in facilities management and need to set the opening angle of a solar panel so it faces the sun correctly. You measure the panel's horizontal projection and its full length, divide one by the other to get a cosine, then use ACOS to find the tilt angle. With ACOS in Excel, you can build a small table of measurements and get all the angles at once, ready for the installation team.
When to use ACOS
- Converting a cosine ratio from distance measurements into a tilt or slope angle.
- Checking the angle between two vectors in engineering or physics coursework.
- Calculating the phase angle from a power factor in electrical load analysis.
- Finding the launch angle in a projectile problem when the cosine component is known.
- Turning a correlation coefficient into an angle for geometric data visualisation.
- Verifying robot arm joint angles from cosine sensor readings in automation logs.
ACOS syntax
=ACOS(number)| Argument | Required? | What to enter |
|---|---|---|
number | Required | The cosine value you want the angle for. It must be between -1 and 1 inclusive. For example, 0.5 returns approximately 1.047 radians (60 degrees). |
What it returns: ACOS returns a number in radians between 0 and pi (approximately 3.14159). To convert to degrees, multiply the result by 180/PI() or use the DEGREES function.
ACOS examples
1 Basic arccosine of a single ratio
This example shows the simplest use: you have a cosine value in a cell and want the angle in radians. The formula =ACOS(B2) reads the value 0.5 from B2 and returns about 1.047 radians, which is 60 degrees. It is a quick way to check a single calculation before building a larger table.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Description | Cosine | |||
| 2 | Known ratio | 0.5 | 1.047197551 | ||
| 3 |
2 Converting a cosine ratio to degrees
ACOS gives radians, but many people think in degrees. Here the cosine value 0.7071 is in B2. The formula =DEGREES(ACOS(B2)) first finds the arccosine in radians, then converts it to degrees. The result is approximately 45 degrees, which is the angle whose cosine is 0.7071.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Cosine | |||
| 2 | Sample A | 0.7071 | 45.00054947 | ||
| 3 |
3 Finding a ramp angle from rise and run
A ramp's cosine is the horizontal run divided by the ramp length. In this table, column B holds the run and column C holds the length. The formula =DEGREES(ACOS(B2/C2)) divides run by length to get the cosine, then converts the arccosine to degrees. For a run of 3 and length of 5, the cosine is 0.6 and the angle is about 53.13 degrees.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Ramp | Run (m) | Length (m) | |||
| 2 | Ramp 1 | 3 | 5 | 53.13010235 | ||
| 3 | Ramp 2 | 4 | 5 | |||
| 4 |
4 Power factor to phase angle
In electrical work, the power factor is the cosine of the phase angle. Column B lists power factors for several loads. The formula =DEGREES(ACOS(B2)) converts the power factor in B2 to a phase angle in degrees. A power factor of 0.8 gives about 36.87 degrees, which helps technicians assess load behaviour.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Load | Power Factor | |||
| 2 | Motor 1 | 0.8 | 36.86989765 | ||
| 3 | Motor 2 | 0.9 | |||
| 4 | Motor 3 | 0.95 | |||
| 5 |
5 Solar panel tilt from projection ratio
For a solar panel, the cosine of the tilt angle equals the horizontal projection divided by the panel length. Column B holds the projection and column C the length. The formula =DEGREES(ACOS(B2/C2)) calculates the tilt angle in degrees. With a projection of 1.2 m and a length of 2 m, the cosine is 0.6 and the tilt is about 53.13 degrees.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Panel | Projection (m) | Length (m) | |||
| 2 | Panel A | 1.2 | 2 | 53.13010235 | ||
| 3 | Panel B | 1.5 | 2 | |||
| 4 |
Common ACOS errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #NUM! | The number argument is outside the range -1 to 1, so no real arccosine exists. | Check that the input is a valid cosine value. If it comes from a division, ensure the numerator is not larger than the denominator, or clamp the value with MEDIAN(-1, value, 1). |
| #VALUE! | The number argument is text or a blank cell that Excel cannot treat as a number. | Make sure the cell contains a numeric value. Remove spaces or text, or use VALUE to convert a text number. |
| #DIV/0! | The formula divides by zero, often when calculating a ratio before ACOS. | Wrap the division in IFERROR or check that the denominator is not zero before applying ACOS. |
| Wrong angle unit | ACOS returns radians, but the user expects degrees. | Wrap the ACOS result in DEGREES or multiply by 180/PI(). |
Tips for using ACOS
- Always confirm the input is between -1 and 1; ACOS cannot handle values outside that range.
- Use
=DEGREES(ACOS(x))when you need degrees instead of radians. - Remember that ACOS returns values from 0 to pi radians, so the result is never negative.
- If your ratio comes from a division, guard against zero denominators with IFERROR.
- For quick checks, 0.5 gives 60 degrees and 0.7071 gives about 45 degrees.
- Combine ACOS with ROUND to present angles neatly in reports, for example
=ROUND(DEGREES(ACOS(B2)),1).
Frequently asked questions
What is the difference between ACOS and COS?
COS gives the cosine of an angle, while ACOS gives the angle whose cosine is a given number. They are inverse operations.
Why does ACOS return radians?
Excel's trigonometric functions use radians by default. Convert to degrees with the DEGREES function or by multiplying by 180/PI().
Can ACOS handle negative numbers?
Yes, as long as the number is between -1 and 1. A negative cosine gives an angle between pi/2 and pi radians (90 to 180 degrees).
What happens if I enter 2 in ACOS?
Excel returns #NUM! because 2 is outside the valid range of -1 to 1 for a cosine value.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. ACOS reference