• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
EngineerExcel

EngineerExcel

FREE EBOOK
  • About
  • Course
  • Free Training
  • Resources
  • Login

Trigonometric Functions in Excel

Excel contains a variety of trigonometric functions:

Basic functions

Hyperbolic functions

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]

Inverse functions

Miscellaneous

SIN SINH ASIN PI()
COS COSH ACOS RADIANS
TAN TANH ATAN DEGREES
SEC SECH ASINH
CSC CSCH ACOSH
COT COTH ATANH

The inverse functions are those usually denoted with a superscript -1 in math (i.e. ASIN is the Excel function for sin-1). These will return an angle given a sine value (or cosine, tangent, etc.).

The “Miscellaneous” column contains functions that are useful in trigonometric calculations. PI() returns the value of π to 15 digits. RADIANS will convert a number from degrees into radians. DEGREES converts from radians into degrees.

It’s important to note that Excel uses radians for all trigonometric functions. If you’re working with angles in degrees, you’ll have to convert into radians before inputting those values into one of these functions. You can use the RADIANS function directly, or you can use the formula:

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]

Let’s say there’s an angle in degrees in cell A1 of your worksheet. You can enter the above formula in the form: =PI()/180*A1. You can also insert that term directly into one of the trig functions. For example, to take the sine of cell A1, enter =SIN(PI()/180*A1) into the formula bar.

Our example worksheet contains a spreadsheet to calculate the sine, cosine and tangent for 0 to 2π. Since the angles are already in radians, it’s straightforward to do these calculations. In the first row, type =SIN( and select the cell containing the angle (C5). Repeat for the cosine =COS(C5) and tangent =TAN(C5). To fill the rest of the table, select all three cells, hover over the fill handle and double-click.

The worksheet will automatically plot the data when you fill in the table. There are undefined values in the tangent at and which appear as ######. You can delete these to clean up the plot.

To calculate the angle in degrees, enter the following into the first cell: =DEGREES(C5). Double-click the fill handle to complete the table. As an exercise, let’s use the angle in degrees as inputs for the sine, cosine and tangent columns. Delete the data in these three columns. In the sine column, enter in the formula: =SIN(RADIANS(B5)). The function to convert B5 to radians is nested within the SIN function. You could also use =SIN(PI()/180*B5) if you prefer to use the formula on the previous page.

Repeat for the cosine and tangent functions: =COS(RADIANS(B5)) and =TAN(RADIANS(B5)), respectively. Highlight the three cells and double-click the fill handle. This gives us the same data as before, but eliminates the need for a separate radians column if your input data is in degrees.

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]

Primary Sidebar

Featured Posts

Complex Matrix Multiplication in Excel

3 Ways to Update a Scatter Chart in Excel

Transferring Excel Charts to Other Software

How to Fit an Equation to Data in Excel

Inserting Rows into Tables of Data

About Me: Charlie Young, P.E.

I’m a licensed professional engineer with a degree in Mechanical Engineering and over a decade of practical experience building engineering applications in Excel. My goal is to help you learn how to turn Excel into a powerful engineering tool.

If you’re interested in learning more, click the button below to receive an update whenever I have a new tip to share. I’ll also send you a copy of my free eBook “10 Smarter Ways to Use Excel for Engineering”.


Subscribe Now

Footer

SOCIAL

Keep up with EngineerExcel:
  • Email
  • RSS
  • YouTube
EngineerExcel

Free Course

Navigation

  • Home
  • About
  • Free Course
  • Excel Tips
  • Resources
  • Coupon
  • Login

Support

  • Support
  • Terms
  • Privacy

Copyright © 2021 EngineerExcel.com · Log in