Trigonometry

X

X_hey_X

I've been told that excel does have a formula for using trigonometry, but i
cannot use it, i did find SIN and COS but when i used them it gave me the
incorrect answer. i typed in "=100*(COS(60))" and it gave me -95.24 when the
answer should be 50, what did i do wrong
 
S

Sloth

You need to use radians, not degrees. Change your formula to

=100*COS(60*PI()/180)
 
K

Ken Johnson

Excel uses radians so you have to use the Radians function to convert
your degrees to radians. =100*COS(RADIANS(60)) returns 50
Ken Johnson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Current Office 365 Subscription vs. New One? 0
Longtitude and Latitude Question 4
Minimum Distance Calculation using Array and Geographical Coordinates 1
How come Excel can't calculate any =SIN(x) or =COS(y) correctly? 6
Trigonometry in Excel 7
How do I use inverse trigonometry in access? 4
Difficulty with compatibility mode and Track Changes 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top