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

Read HELP: radians or degrees

--
Kind regards,

Niek Otten

"X_hey_X" <[email protected]> wrote in message
news:[email protected]...
> 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

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

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