5 Ways to Calculate Inverse Cosine in Microsoft Excel

Are you wondering how to calculate inverse cosine in Excel? You’ve landed on the appropriate Excel tutorial. Keep reading to learn more!

As a data analyst professional, you might need to calculate angles, side length ratios, height, distance, etc., in engineering and physics. Or you’re an engineering graduate or instructor and must figure out such values for learning purposes.

Excel functions for mathematics and trigonometry will come in handy in such scenarios. In today’s Excel tutorial, I explain various intuitive ways of calculating the inverse cosine in Excel.

To know more about the inverse values (radians or degrees) of sine and tan, read these articles already covered by me:

5 Ways to Calculate Inverse Sine in Microsoft Excel

5 Ways to Calculate Inverse Tan in Microsoft Excel

What Is Inverse Cosine?

Inverse cosine (cos) is a mathematical function that operates as the inverse value of the given cosine value or the ratio of the adjacent side and hypotenuse of the right-angle triangle. You can denote it as cos^-1 or arccos or arccosine.

Usually, the cosine function accepts an angle as an input. Then, it returns the ratio of the adjacent side to the hypotenuse in a right triangle. However, inverse cosine does the opposite.

If a trigonometrical problem has the ratio between the adjacent side and the hypotenuse, you can calculate the degree of the acute angle horizontally opposite to the right angle. However, the ratio or the cosine value must be within the range of -1 to 1.

In mathematical terms, the domain of the arccosine function is [-1, 1], and its output (range) is typically [0, π] radians or [0, 180] degrees since it represents angles in the first and second quadrants of the unit circle.

Reasons to Calculate Inverse Cosine

  1. Inverse cosine helps determine an angle when you know the ratio of the adjacent side to the hypotenuse in a right triangle. This is especially useful in fields like trigonometry and geometry.
  2. When you’re solving trigonometric equations you often need to find angles with specific cosine values. Inverse cosine helps obtain these angles.
  3. In various engineering and physics applications, it’s necessary to find angles that correspond to certain cosine values either as a ratio or values given as the lengths of the adjacent side and the hypotenuse.
  4. In navigation and astronomy, determining angles based on celestial bodies’ positions can be done using inverse cosine calculations.
  5. When designing robotic arms or working on computer graphics, you might need to calculate angles for proper positioning. Inverse cosine aids in such calculations.
  6. In signal processing and statistics, determining phase shifts or angles of vectors can involve inverse cosine calculations for accurate error analysis.

Inverse Cosine Calculation Using ACOS Function

The native trigonometric function of Excel to calculate the inverse cosine values for given cos values is the ACOS function.

It’s available in Microsoft Excel desktop editions for Windows since Excel 2007. Also, you’ll find the function in Excel for the web.

Get Inverse Cosine in Excel From Side Lengths

Using ACOS to calculate inverse cosine in Excel
Using ACOS to calculate inverse cosine in Excel

Suppose you got the side lengths and you need to find the inverse cosine. Here are the steps you must follow:

  1. Let’s consider column A contains Adjacent Side and column B contains the Hypotenuse values.
  2. In C2, enter the following formula:
=DEGREES(ACOS(A2/B2))
  1. Hit Enter to get the arccosine value or angle in degrees.
Using fill handle to copy formula
Using the fill handle to copy the formula
  1. If there are more values in columns A and B, simply drag down the auto-fill handle from the cell C2 to instantly get inverse cosine.

Do you need the inverse cosine value in radians instead of degrees? Use the following formula instead:

=ACOS(A2/B2)

Calculate Inverse Cosine From Cosine

Getting inverse cosine from cos
Getting inverse cosine from cos

Finding the inverse cosine from given cos values is a super easy task. Here’s what you need to do:

  1. Highlight a cell adjacent to the first cos value on your worksheet.
  2. Put the following formula into the selected cell and hit Enter:
=ACOS(A2)
Use auto fill to copy paste formula
Use auto-fill to copy paste formula
  1. If there are more cos values in the source data column, simply drag the fill handle from the calculated cell to convert cos values to arccosine values.

Data generated using the ACOS function is always in the radians unit. If you need the output values in degrees, use the following formula instead:

=DEGREES(ACOS(A2))

Calculate Inverse Cosine Using Power Query

Importing datasets to Power Query from external sources
Importing datasets to Power Query from external sources

Power Query is suitable for arccosine calculation for both imported and internet data sources.

However, when importing from external sources, you can transform data in Power Query to inverse cosine. Then, only enter arccosine values to the worksheet if you don’t need the raw data anymore. Here’s how to proceed:

  1. Click the Data tab and select the Get Data button inside the Get & Transform Data block.
  2. From the Get Data context menu, choose your preferred data source like From Azure, From Database, etc.
  3. You should now see your datasets in the Power Query tool.
Selecting worksheet data for Power Query
Selecting worksheet data for Power Query
  1. If you need to import data from the existing worksheet, highlight the data and click the Data tab.
  2. There, select the From Table/Range button.
  3. On the Create Table dialog box, click OK to import and open the internal dataset in Power Query.
Imported cos data in Power Query
Imported cos data in Power Query
Creating new column with formula in Power Query
Creating a new column with a formula in Power Query

Now, follow these steps to learn how to create a new column for inverse cosine in Power Query and insert a formula in it to calculate arccosine for the whole column:

  1. Click the Add Column tab on the Power Query ribbon.
  2. Inside the General block, select the Custom Column button.
  3. On the Custom Column dialog box, give a name to the new column in the New column name field.
  4. Inside the Custom column formula field, enter the following formula:
Number.Acos([Cosine])
  1. Click OK.
Calculate inverse cosine using Power Query
Calculate inverse cosine using Power Query

Now, you should see the new column on the Power Query tool. It also shows the cos to inverse cosine converted values. The formula will work in your worksheet as long as the source data column header is Cosine.

If it’s something else, modify the formula accordingly. You simply need to put the column header as is inside the square brackets in the above formula.

Converting radians to degrees in Power Query
Converting radians to degrees in Power Query

The arccosine values calculated this way are radian values. If you need the values in degrees, follow these steps on the Power Query tool:

  1. Create a new custom column by following the instructions mentioned earlier.
  2. On the Custom Column wizard, give a new name for the custom column.
  3. Inside the column formula field, enter this formula:
([Inverse Cosine])*(180/Number.PI)
  1. Click OK.
Radians to degrees in Excel
Radians to degrees in Excel

The new column will appear with the converted values from radians to degrees. To modify the formula according to your own dataset, simply put the column header name as is in the square brackets, in place of Inverse Cosine.

Import data from Power Query
Import data from Power Query

Now that you’ve completed the data transformation process, here’s how you can import the converted data into your Excel worksheet:

  1. Click the File menu and choose Close & Load To.
  2. On the Import Data dialog box, click Existing worksheet and highlight a cell as the destination.
  3. Click OK.
Inverse cosine in Power Query
Inverse cosine in Power Query
  1. Power Query will export the new and existing columns to the highlighted worksheet.

Calculate Inverse Cosine in Power Pivot (DAX)

Add data to data model
Add data to data model

You can use the Data Analysis Expressions (DAX), ACOS, on Power Pivot to calculate inverse cosine in bulk for the entire column. Later, you can import the converted values to a PivotTable or the Excel worksheet. Here are the steps you must try:

  1. Highlight the input cos values and click the Power Pivot tab.
  2. There, select the Add to Data Model button.
  3. On the Create Table dialog, click OK.
  4. The highlighted data will now open in the Power Pivot tool.
Entering DAX formula in Power Pivot columns
Entering the DAX formula in the Power Pivot columns
  1. Click the Add Column placeholder text and rename it to Inverse Cosine.
  2. Select the newly-created Inverse Cosine column and click the formula bar to enter this DAX formula:
=(ACOS([Cosine])*(180/Pi()))
  1. Hit Enter to convert cos to inverse cosine in degrees instantly for the whole input data column.
Sample of inverse cosine data in Power Pivot
Sample of inverse cosine data in Power Pivot

The above image shows the results after the conversion. If you need inverse cosine in radians, use this formula instead:

=ACOS([Cosine])
Copy data on Power Pivot
Copy data on Power Pivot

Now, to import these values into your Excel worksheet, right-click on the Inverse Cosine column on Power Query and click Copy on the context menu.

Highlight and choose CSV for importing
Highlight and choose CSV for importing

Highlight the destination cell and press Ctrl + Alt + V. On the Paste Special dialog box, click Csv and hit OK.

Calculate inverse cosine using Power Pivot
Calculate inverse cosine using Power Pivot

You should now see the inverse cosine values on the worksheet.

Calculate Inverse Cosine in Excel VBA

The methods explained so far are a bit manual. You’re performing a few steps or you need to remember the steps before you can get arccosine values in Excel.

However, if you’re okay with learning basic Excel VBA scripting, you can automate the process to a great extent.

Read this easy and intuitive article to learn how to use Excel VBA scripts on your worksheets:

How To Use The VBA Code You Find Online

Now that you know how to utilize Excel VBA scripts, find below two scripts you can use to convert cos to inverse cos in Excel:

Excel VBA Script for Arccosine From Side Lengths

Excel VBA Script for Arccosine From Side Lengths
Sub CalculateInverseCosine()
    Dim ws As Worksheet
    Dim adjacentRange As Range
    Dim hypotenuseRange As Range
    Dim cell As Range
    
    ' Set the worksheet
    Set ws = ThisWorkbook.Sheets("Sheet2") ' Replace "Sheet2" with your actual sheet name
    
    ' Set the input ranges
    Set adjacentRange = ws.Range("A2:A5") ' Change this range as needed
    Set hypotenuseRange = ws.Range("B2:B5") ' Change this range as needed
    
    ' Loop through the corresponding cells in adjacent and hypotenuse ranges
    For Each cell In adjacentRange
        ' Find the corresponding hypotenuse value in the same row
        Set hypotenuseCell = hypotenuseRange.Cells(cell.Row - adjacentRange.Cells(1).Row + 1)
        
        ' Calculate inverse cosine in radians
        cell.Offset(0, 2).Value = WorksheetFunction.Acos(cell.Value / hypotenuseCell.Value)
        
        ' Calculate inverse cosine in degrees
        cell.Offset(0, 3).Value = WorksheetFunction.Acos(cell.Value / hypotenuseCell.Value) * (180 / WorksheetFunction.Pi())
    Next cell
End Sub

The above VBA script will help you convert cosine values in a cell range to inverse cosine values. You’ll get inverse cosine in radians in column C and in degrees in column D.

If you don’t need values in radians, delete the following code line from the above script:

cell.Offset(0, 2).Value = WorksheetFunction.Acos(cell.Value / hypotenuseCell.Value)

Also, if you just need the results in radians but not degrees, delete this code line from the script:

cell.Offset(0, 3).Value = WorksheetFunction.Acos(cell.Value / hypotenuseCell.Value) * (180 / WorksheetFunction.Pi())

To help you modify the script, I’ve also included comments in the code snippet. Follow the comments and modify the script according to your worksheet.

Excel VBA Script for Inverse Cosine From Cosine

Excel VBA Script for Inverse Cosine From Cosine
Sub CalculateInverseCosine()
    Dim ws As Worksheet
    Dim cosineRange As Range
    Dim resultRangeRadians As Range
    Dim resultRangeDegrees As Range
    Dim cell As Range
    
    ' Set the worksheet
    Set ws = ThisWorkbook.Sheets("Sheet7") ' Replace "Sheet7" with your actual sheet name
    
    ' Set the input cosine range and result ranges
    Set cosineRange = ws.Range("A2:A5") ' Change this range as needed
    Set resultRangeRadians = ws.Range("B2:B5") ' Change this range as needed for radians
    Set resultRangeDegrees = ws.Range("C2:C5") ' Change this range as needed for degrees
    
    ' Loop through the cosine values
    For Each cell In cosineRange
        ' Calculate inverse cosine in radians
        resultRangeRadians.Cells(cell.Row - cosineRange.Cells(1).Row + 1).Value = WorksheetFunction.Acos(cell.Value)
        
        ' Calculate inverse cosine in degrees
        resultRangeDegrees.Cells(cell.Row - cosineRange.Cells(1).Row + 1).Value = WorksheetFunction.Acos(cell.Value) * (180 / WorksheetFunction.Pi())
    Next cell
End Sub

Use the above VBA script to convert cosine values to arccosine in a few clicks for a large range of source data.

Use Office Scripts to Calculate Inverse Cosine

Find below two distinct methods to convert input data source to inverse cosine in Excel using Office Scripts:

Office Scripts Code for Arccosine From Side Lengths

Using Office Scripts to calculate inverse cosine
  1. Click the Automate button on the Excel desktop or web app.
  2. Select the New Script button.
  3. Copy and paste the following script into the Code Editor:
function main(workbook: ExcelScript.Workbook) {
	let selectedSheet = workbook.getActiveWorksheet();
	// Set range C2 on selectedSheet
	selectedSheet.getRange("C2").setFormulaLocal("=ACOS(A2/B2)");
	// Auto fill range
	selectedSheet.getRange("C2").autoFill("C2:C5", ExcelScript.AutoFillType.fillDefault);
	// Set range D2 on selectedSheet
	selectedSheet.getRange("D2").setFormulaLocal("=DEGREES(ACOS(A2/B2))");
	// Auto fill range
	selectedSheet.getRange("D2").autoFill("D2:D5", ExcelScript.AutoFillType.fillDefault);
}
  1. Click the Save script button to save the code.
  2. Hit the Run button to execute the code.

Here’s how to modify the script:

  • C2 is the destination of results, so change accordingly.
  • In the ACOS formula, A2 represents adjacent side length and B2 represents hypotenuse. So, alter these references according to your worksheet.
  • C2:C5 is for formula auto-fill. So, change this cell range reference as well. For example, if input data exists till A100 and B100, then C2:C5 should be C2:C100.
  • D2 is the destination for inverse cosine in degrees.
  • Also, change D2:D5 if input data in columns A and B are more than four rows.

Office Scripts Code for Arccosine From Cosine

Using Office Scripts for inverse cosine
function main(workbook: ExcelScript.Workbook) {
	let selectedSheet = workbook.getActiveWorksheet();
	// Set range B2 on selectedSheet
	selectedSheet.getRange("B2").setFormulaLocal("=ACOS(A2)");
	// Auto fill range
	selectedSheet.getRange("B2").autoFill("B2:B5", ExcelScript.AutoFillType.fillDefault);
	// Set range C2 on selectedSheet
	selectedSheet.getRange("C2").setFormulaLocal("=DEGREES(ACOS(A2))");
	// Auto fill range
	selectedSheet.getRange("C2").autoFill("C2:C5", ExcelScript.AutoFillType.fillDefault);
}

The above Office Scripts code will produce inverse cosine in radian in column C and in degrees in column D.

Don’t forget to modify the script before using it in your own worksheet.

Note: Office Scripts is only available with a paid Microsoft 365 subscription. Also, the subscription plan must be a Business Standard plan or higher.

Conclusion

These are all the methods Excel offers to you so you can get inverse cosine from different input data sources. Follow along with the steps for the above methods to get the data you need.

Also, comment below to express your own experience in trying the above techniques.

About the Author

Bipasha Nath

Bipasha Nath

Bipasha is a technical content writer with 10+ years of experience in the technology industry. She previously worked in a SaaS software development company focused on SharePoint, OneDrive, Word, Excel, Word solutions.

Related Posts

Comments

0 Comments

Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃