Formula Errors

Fix Excel ACOS Errors for -1 and 1

Khadija KhanKhadija Khan Nov 22, 2026 868 views

Question details

The user needs Excel to calculate the inverse cosine of values that appear to be -1 or 1.

Fix Excel ACOS Errors for -1 and 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.
Before you start

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.

Solution 1Recommended

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.

1
Test the endpoints

Enter =ACOS(1) and =ACOS(-1) in empty cells. Both should return valid results in radians.

2
Check the input

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.

3
Constrain the value

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.

Check the calculated input and constrain precision errors
Check substantial discrepancies: Constraining the input also hides larger out-of-range values. Investigate the underlying formula if the result is not expected to be close to -1 or 1. Use semicolons instead of commas if your regional settings require them.
Calculate with WPS Spreadsheets

Calculate inverse cosine values in WPS Spreadsheets

Use WPS Spreadsheets to calculate ACOS values and constrain small precision errors in a spreadsheet formula.

  1. 1. Open the workbook: Open WPS Spreadsheets and choose Open to select your Excel workbook, or create a blank spreadsheet.
  2. 2. Enter the input: Type a value from -1 through 1 in cell A1, or use a cell containing your calculated input.
  3. 3. Calculate ACOS: In an empty cell, enter =ACOS(A1) to calculate the inverse cosine in radians.
  4. 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.
Calculate inverse cosine values with ACOSUse MAX and MIN to constrain an expected input rangeOpen and edit Microsoft Excel XLSX filesWork in a familiar spreadsheet interface
microsoft office alternative - wps office

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.