Fix Excel ACOS Errors for -1 and 1
Question details
The user needs Excel to calculate the inverse cosine of values that appear to be -1 or 1.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A formula supplies an endpoint value to the ACOS function.
- Observed behavior
- Excel returns an error even though the displayed input appears to be -1 or 1.
Identify the cell or formula supplying the ACOS input. Check whether the value is entered directly or calculated, and use the argument separator required by your regional settings.
Check the calculated input and constrain precision errors
Use this method when a calculated value appears to be -1 or 1 but is slightly outside the valid range.
ACOS accepts values from -1 through 1, including both endpoints. Floating-point calculations can produce a value just outside that range even when the cell displays an endpoint.
Enter =ACOS(1) and =ACOS(-1) in empty cells. Both should return valid results in radians.
If the ACOS input is in A1, enter =A1>1 and =A1<-1 in empty cells. A TRUE result indicates that the stored value is outside the valid range.
If the out-of-range result is an expected precision error, replace =ACOS(A1) with =ACOS(MAX(-1,MIN(1,A1))). You can substitute the original calculation for A1.

Calculate inverse cosine values in WPS Spreadsheets
Use WPS Spreadsheets to calculate ACOS values and constrain small precision errors in a spreadsheet formula.
- 1. Open the workbook: Open WPS Spreadsheets and choose Open to select your Excel workbook, or create a blank spreadsheet.
- 2. Enter the input: Type a value from -1 through 1 in cell A1, or use a cell containing your calculated input.
- 3. Calculate ACOS: In an empty cell, enter =ACOS(A1) to calculate the inverse cosine in radians.
- 4. Handle precision errors: If A1 is expected to be in range but is slightly outside it due to calculation precision, enter =ACOS(MAX(-1,MIN(1,A1))) instead. Use your regional argument separator.

Frequently Asked Questions
Are -1 and 1 valid inputs for Excel ACOS?
Yes. Enter =ACOS(-1) or =ACOS(1) in a cell to calculate the endpoint results. ACOS accepts the entire range from -1 through 1.
Why does a displayed value of 1 cause a #NUM! error?
The underlying calculated value may be slightly greater than 1, even if the cell displays 1. If the input is in A1, enter =A1>1 in another cell to check.
Does ACOS return degrees or radians?
ACOS returns radians. To convert the result to degrees, enter =DEGREES(ACOS(A1)), where A1 contains the input.
What if Excel rejects the formula syntax?
Check your regional settings and use the required argument separator. For example, replace commas with semicolons in the MAX and MIN formula if your Excel installation requires semicolons.




