Solving Trigonometric Equations with Excel (Vista)

Click For Summary
SUMMARY

This discussion focuses on using Excel (Vista) to solve trigonometric equations by converting angles from degrees to radians. Users must utilize the RADIANS and DEGREES functions to ensure accurate calculations of sine and cosine values. Specifically, the formula =SIN(RADIANS(Angle)) is necessary to obtain correct results when inputting angles in degrees. The consensus is that while most software defaults to radians, understanding this conversion is essential for accurate trigonometric function results.

PREREQUISITES
  • Familiarity with Excel (Vista) functions
  • Understanding of trigonometric functions (sine, cosine)
  • Knowledge of angle measurement units (degrees and radians)
  • Basic mathematical conversion techniques
NEXT STEPS
  • Learn how to use the RADIANS function in Excel for angle conversion
  • Explore the DEGREES function in Excel for converting radians back to degrees
  • Investigate the implications of using radians in programming languages
  • Study the properties of trigonometric functions and their applications in Excel
USEFUL FOR

This discussion is beneficial for Excel users, mathematicians, and anyone involved in data analysis or engineering who requires accurate trigonometric calculations in degrees.

drizzle
Gold Member
Messages
200
Reaction score
58
:blushing:

using excel (vista) how can I reverse the number to be in degrees rather than radians if I want to use trigonometric functions? I have to reverse the number of the angle in radian to use those functions and I want them to be in degrees, anyone know how, thanks in advance.
 
Physics news on Phys.org
=RADIANS (Angle)
=DEGREES(Angle)
 
thanks mgb_phys, but I have this data of angles [in degrees], and I want to calculate cos/sin of these angles, and I have to convert them to radians in order to get the trigonometric functions correctly, i.e.
if I type in a cell [=sin(90)] I get this value [0.893997], while [=sin(radians(90))] would give the correct answer which is 1, does it have to be in radians to get those functions correct? is it not possible to have these function in the form of [sin(number in degrees)]?

[I know they would give the same results, but I want them to be in degrees]
 
Yes you have to do =sin(radians(90))
 
You could just divide the angle in degrees by 57.29577951 to convert to radians.
 
You'll find most software, along with computer languages use radians. Might as well get used to it.
 

Similar threads

Replies
8
Views
2K
  • · Replies 14 ·
Replies
14
Views
2K
  • · Replies 6 ·
Replies
6
Views
2K
  • · Replies 25 ·
Replies
25
Views
3K
  • · Replies 19 ·
Replies
19
Views
1K
  • · Replies 4 ·
Replies
4
Views
2K
Replies
9
Views
2K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 26 ·
Replies
26
Views
1K
  • · Replies 5 ·
Replies
5
Views
14K