Excel COS Function: Syntax, Examples & Tips

The COS function calculates the cosine of an angle in radians, aiding in precise trigonometric analysis within Excel.
Excel
=COS(number)

One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.

Need more than a single COS formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.

On this page
  1. Parameters
  2. What is a COS Formula in Excel?
  3. A Practical Example
  4. COS Formula
  5. Result of the Formula
  6. Why Use COS?
  7. Key Takeaways:
  8. Example use case

Parameters

number:
The angle in radians for which you want to calculate the cosine. This can be a number, a cell reference, or a formula that returns a numeric value.

What is a COS Formula in Excel?

The COS function in Excel is a mathematical tool that calculates the cosine of a given angle. The angle must be provided in radians, and the function returns the cosine value, which is a fundamental concept in trigonometry.

In simpler terms, the COS function helps you find the cosine of an angle, which is useful in various mathematical and engineering applications, including physics, geometry, and computer graphics.

A Practical Example

Imagine you are working on a project that involves calculating the horizontal distance of a projectile launched at a certain angle. You have the following data in an Excel spreadsheet:

Projectile Data Table:

Launch Angle (degrees)Launch Angle (radians)Horizontal Distance
30=RADIANS(A2)
45=RADIANS(A3)
60=RADIANS(A4)

You want to calculate the cosine of each launch angle to help determine the horizontal distance.

COS Formula

To calculate the cosine of the launch angle in radians, you would use the COS formula as follows:

Excel
=COS(B2)

Breakdown of the Formula:

  • B2: This is the cell that contains the angle in radians for which you want to calculate the cosine.

Result of the Formula

When you apply the formula, it calculates the cosine of the angle in cell B2. The output would be:

Launch Angle (degrees)Launch Angle (radians)Horizontal Distance
300.52360.866
450.78540.707
601.04720.500

Here, the cosine values for 30°, 45°, and 60° are calculated as approximately 0.866, 0.707, and 0.500, respectively.

Why Use COS?

The COS function is particularly useful when you need to perform calculations involving angles in trigonometry. It allows you to easily derive cosine values, which are essential for solving problems related to waves, oscillations, and circular motion.

Key Takeaways:

  • COS: Calculates the cosine of an angle provided in radians.
  • Mathematical Applications: Useful in trigonometry, physics, and engineering calculations.
  • Common Use Cases: Ideal for analyzing waveforms, calculating distances in projectile motion, and any scenario involving angles.

Understanding how to use the COS function can significantly enhance your mathematical calculations in Excel, enabling you to solve complex problems involving angles and trigonometric functions.

Happy calculating!

Example use case

You have a table where Column A contains angles in degrees and you want to calculate the cosine of each angle in Column B. You can use the COS function to convert the angles from degrees to radians and then compute their cosine values. This allows for quick calculations in trigonometric applications, such as in physics or engineering, without needing to manually convert the angles or use a calculator for each value.

Beyond the COS function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.

Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.

Need more help with Excel formulas?

Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.

Explore all Excel formulas

Browse our complete library of Excel formula guides

Compare your options

Decide with evidence, not a sales pitch.

Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.

  1. 01ChatGPTOpen a balanced comparison prompt in ChatGPT.
  2. 02ClaudeOpen the same research prompt in Claude.
  3. 03PerplexityResearch the comparison with linked web sources.

AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.

COS Function in Excel - Better Analyst