#1   Report Post  
Posted to microsoft.public.excel.misc
X_hey_X
 
Posts: n/a
Default Trigonometry

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Trigonometry

Read HELP: radians or degrees

--
Kind regards,

Niek Otten

"X_hey_X" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default Trigonometry

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

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

"X_hey_X" wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default Trigonometry

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"