{"id":2883,"date":"2017-10-11T00:36:56","date_gmt":"2017-10-11T00:36:56","guid":{"rendered":"http:\/\/excelvbatutor.com\/?page_id=2883"},"modified":"2020-04-23T11:01:47","modified_gmt":"2020-04-23T11:01:47","slug":"excel-vba-lesson-7-trigonometric-functions","status":"publish","type":"page","link":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-lesson-7-trigonometric-functions\/","title":{"rendered":"Excel VBA Lesson 7: Trigonometric Functions"},"content":{"rendered":"\n

<<Lesson 6>><\/a> [Contents] <\/a><<Lesson 8>><\/a><\/strong><\/h4>\n\n\n\n

In the previous lesson, we have learned how to write code using various mathematical functions in Excel VBA. In this lesson, we shall proceed to learn how to work with trigonometric functions.The three basic trigonometric functions are Sin, Cos and Tan which stand for sine, cosine and tangent. We also deal with the inverse of tangent, Atn.<\/p>\n\n\n\n

7.1 The Sin function<\/h3>\n\n\n\n

The Sin function returns the sine value of an angle. We need to convert the angle to radian as Excel VBA cannot deal with the angle in degree.
\nThe conversion is based on the following equation:<\/p>\n\n\n\n

\u03c0 radian= 180o<\/sup>
\nso 1o<\/sup>=\u03c0\/180 radian<\/p>\n\n\n\n

The issue is how to get the exact value of p? We can use p=3.14159 but it will not be accurate.
\nTo get exact value of \u03c0, we use the arc tangent function, i.e. is Atn. Using the equation tan(\u03c0\/4)=1, so Atn(1)=\u03c0\/4, therefore, \u03c0=4Atn(1)<\/p>\n\n\n\n

The syntax of the Sin function in Excel VBA is<\/p>\n\n\n\n

Sin(Angle in radian)<\/p>\n\n\n\n