LiveFlow raises $13.5 million Series A led by New York-based Valar Ventures and launches LiveFlow Next to revolutionize accounting!
Read More
Arrow
Back to guides
Excel Formulas

Understanding the SIN Function in Excel: A Step-by-Step Guide

In this article, you will learn how to use the SIN function in Excel. 

What is the SIN function in Excel?

In Excel, the SIN function is used to calculate the sine of a given angle in radians. This function is especially useful in mathematics, engineering, and various scientific domains where trigonometry is needed.

When is it helpful to use the SIN function in Excel?

Using the SIN function in Excel is helpful in various fields and scenarios where trigonometry plays a role. Here are a few examples of when it can be beneficial to use the SIN function:

  • Engineering: Engineers often need to perform trigonometric calculations for design, analysis, and simulation of structures, mechanical parts, or electrical circuits. For example, in civil engineering, the SIN function might be used to calculate the stress and strain on bridges or other structures due to different load angles.
  • Economics and Finance: Although not as common, trigonometric functions like SIN can sometimes be used in economic models and financial analysis.
  • Architecture: Architects might use the SIN function to model and analyze the effects of sunlight on buildings (solar geometry) to design more efficient and comfortable spaces.

How to use the SIN function in Excel

The syntax for the SIN function in Excel is the following:

=SIN(number)

Number: This is a required argument that is the angle in radians for which you want to find the sine of. 

Note: If you want to input the number argument in degrees you can do two things to convert the degrees to radians:

  1. You could use the RADIANS function which has the syntax =RADIANS(angle). You would simply plug in the angle value you have in degrees and the function will return the angle in radians. And so you could use this function in conjunction with the SIN function such that the syntax would be the following: =SIN(RADIANS(angle)).
  2. You could multiply your angle value in degrees by PI()/180 (the PI() function returns the value of pi).

Below is a very simple example and look at how the SIN function works in Excel.

Example of using the SIN function in Excel

As seen in the image above, we made sure to first convert the degrees to radians, we did this within the SIN function.

What is the difference between using the SIN function and the COS function in Excel?

The SIN and COS functions in Excel are both trigonometric math functions. The main difference between the two functions is that the SIN function returns the sine of the angle, while the COS function returns the cosine of the angle. While this seems self-explanatory and quite obvious, what may be challenging is knowing when to use each function and in what circumstances one may be better suited than the other

The COS function is essentially the same as the SIN function, but it is shifted by 90 degrees, or π/2 radians, to the right. This means that for any given angle, the cosine of that angle is equal to the sine of the angle plus 90 degrees (or π/2 radians). In practical terms, whether you use SIN or COS in Excel will depend on the specific problem you're solving and how your input data is phased.

Go to the page LiveFlow‘s How to Guides to find more information about Excel and Google Sheets formulas and tips that were not covered here.

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how!

Get personal help

We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.
Blue Tick
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below

Supercharge your financial reporting today

See LiveFlow in action and discover how to streamline your workflows.