While working in Microsoft Excel, we sometimes apply trigonometric formulas and do not get the proper output we expect. When we try to find the value of cos 90 inside an Excel sheet, it does not display zero. But it can be made zero with proper utilization of formulas. Here in this article, I will discuss why cos 90 does not return its exact value and also demonstrate an effective way to return the value of cos90 as zero in Excel.
Reason Behind Cos 90 Not Equal to Zero (0) in Excel
In Trigonometry, we all know cos(90)=0. But when we apply the formula in Excel using the COS function it does not show zero rather it gives us this value- “6.12574E-17”.
There is an interesting concept behind this faulty result. We know that the Cosine operator works using radian values rather than value of degree. If you insert a number it will first convert the value in radians which is basically =the input number*pi (Π)/180.
So, for Cos 90 this will be,
But here is the catch! pi (Π) is an infinite decimal so it will never return a definite value and Excel will somewhere cut this number and give a very slightly inaccurate result. So, therefore, excel is giving you the value of Cos 90 as 6.12574E-17, which is not zero, but very close to zero for the inaccuracy in the radian value.
How to Return Cos 90 as Zero (0) in Excel: 3 Simple Steps
In the following, I have shared 3 simple steps to return the value of Cos 90 as zero in Excel.
Suppose we have a dataset with an Angle of 90 degrees. Now we will calculate the Radian and then apply the COS function to figure out whether the cos 90 is zero or not.
Step 1: Convert Degree to Radians
- First, let’s start with converting the numeric value to radian using the RADIANS function. Simply, choose a cell (C5) and write the following formula down-
- Second, hit Enter and the numeric value will be converted to an angle.
Read More: Cos Squared in Excel
Step 2: Find Out Value of Cos 90 in Excel
- Here, we will determine the result of Cos90 using the COS function in Excel.
- Similarly, select a cell (D5) and apply the following formula-
- Click Enter and the output will be shown- “6.12574E-17” which is not our expected output.
Step 3: Combine ROUND, COS, and RADIANS Functions to Return Correct Value of Cos 90
- In order to get the actual output, we have to round the number to remove its inaccuracy. Thus, let’s start with choosing a cell (E5) and write the following formula-
- Press Enter and the rounding result will be in our hands as we expected.
Things to Remember
- While applying the COS function don’t forget to convert the numeric value to an angle using the RADIANS function.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
In this article, I have tried to cover all the methods to return the value of cos 90 and solve the reasons why cos 90 is not zero in Excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. Stay tuned and keep learning.