Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|