# How come Excel can't calculate any =SIN(x) or =COS(y) correctly?

1. ## How come Excel can't calculate any =SIN(x) or =COS(y) correctly?

Hi,

I work with Excel on this math report and the formula I typed in just kept
not working properly. The results were all off. So I checked everything very
carefully and found out why it didn't work. In need to calculate sin and cos
so I typed =SIN(45) in one cell and =COS(45) in another cell just to check if
it works and ... Surprise! I ended up with two different results instead of
0,707 for both!!! I tried with =SIN(0), =SIN(180) and =SIN(360) and again ...
wrong (supposed to be "0" for all of them). If someone knows a way to fix
that, it would be of great help!

By the way, Happy Valentine Day!

2. ## RE: How come Excel can't calculate any =SIN(x) or =COS(y) correctly?

The trig functions use radians, not degrees. Try =SIN(45*PI()/180).

"Shinygaia" wrote:

> Hi,
>
> I work with Excel on this math report and the formula I typed in just kept
> not working properly. The results were all off. So I checked everything very
> carefully and found out why it didn't work. In need to calculate sin and cos
> so I typed =SIN(45) in one cell and =COS(45) in another cell just to check if
> it works and ... Surprise! I ended up with two different results instead of
> 0,707 for both!!! I tried with =SIN(0), =SIN(180) and =SIN(360) and again ...
> wrong (supposed to be "0" for all of them). If someone knows a way to fix
> that, it would be of great help!
>
> By the way, Happy Valentine Day!
>

3. ## Re: How come Excel can't calculate any =SIN(x) or =COS(y) correctly?

or
=SIN(45*PI()/180)

Shinygaia wrote:
>
> Hi,
>
> I work with Excel on this math report and the formula I typed in just kept
> not working properly. The results were all off. So I checked everything very
> carefully and found out why it didn't work. In need to calculate sin and cos
> so I typed =SIN(45) in one cell and =COS(45) in another cell just to check if
> it works and ... Surprise! I ended up with two different results instead of
> 0,707 for both!!! I tried with =SIN(0), =SIN(180) and =SIN(360) and again ...
> wrong (supposed to be "0" for all of them). If someone knows a way to fix
> that, it would be of great help!
>
> By the way, Happy Valentine Day!

--

Dave Peterson

4. ## Re: How come Excel can't calculate any =SIN(x) or =COS(y) correctly?

In Excel, angles should be expressed in Radians, not degrees

--
Kind regards,

Niek Otten

"Shinygaia" <Shinygaia@discussions.microsoft.com> wrote in message
news:D8B2CE13-F7B0-4142-902A-C93388B4E240@microsoft.com...
> Hi,
>
> I work with Excel on this math report and the formula I typed in just kept
> not working properly. The results were all off. So I checked everything
> very
> carefully and found out why it didn't work. In need to calculate sin and
> cos
> so I typed =SIN(45) in one cell and =COS(45) in another cell just to check
> if
> it works and ... Surprise! I ended up with two different results instead
> of
> 0,707 for both!!! I tried with =SIN(0), =SIN(180) and =SIN(360) and again
> ...
> wrong (supposed to be "0" for all of them). If someone knows a way to fix
> that, it would be of great help!
>
> By the way, Happy Valentine Day!
>

5. ## Re: How come Excel can't calculate any =SIN(x) or =COS(y) correctly?

BTW,

One simple check in HELP would have told you

--
Kind regards,

Niek Otten

"Niek Otten" <nicolaus@xs4all.nl> wrote in message
news:e%23NzS9ZMGHA.2472@TK2MSFTNGP11.phx.gbl...
> In Excel, angles should be expressed in Radians, not degrees
>
>
> --
> Kind regards,
>
> Niek Otten
>
> "Shinygaia" <Shinygaia@discussions.microsoft.com> wrote in message
> news:D8B2CE13-F7B0-4142-902A-C93388B4E240@microsoft.com...
>> Hi,
>>
>> I work with Excel on this math report and the formula I typed in just
>> kept
>> not working properly. The results were all off. So I checked everything
>> very
>> carefully and found out why it didn't work. In need to calculate sin and
>> cos
>> so I typed =SIN(45) in one cell and =COS(45) in another cell just to
>> check if
>> it works and ... Surprise! I ended up with two different results instead
>> of
>> 0,707 for both!!! I tried with =SIN(0), =SIN(180) and =SIN(360) and again
>> ...
>> wrong (supposed to be "0" for all of them). If someone knows a way to fix
>> that, it would be of great help!
>>
>> By the way, Happy Valentine Day!
>>

>
>

6. ## RE: How come Excel can't calculate any =SIN(x) or =COS(y) correctly?

*Knocks her head on the table*

I COMPLETLY forgot about radian and worst of all I knew it!!! *sigh* So much
time wasted on something as easy as that... what a shame!!! lol

Thanks to all of you guys!

"Shinygaia" wrote:

> Hi,
>
> I work with Excel on this math report and the formula I typed in just kept
> not working properly. The results were all off. So I checked everything very
> carefully and found out why it didn't work. In need to calculate sin and cos
> so I typed =SIN(45) in one cell and =COS(45) in another cell just to check if
> it works and ... Surprise! I ended up with two different results instead of
> 0,707 for both!!! I tried with =SIN(0), =SIN(180) and =SIN(360) and again ...
> wrong (supposed to be "0" for all of them). If someone knows a way to fix
> that, it would be of great help!
>
> By the way, Happy Valentine Day!
>

7. ## Re: How come Excel can't calculate any =SIN(x) or =COS(y) correctly?

:-}

--
Kind regards,

Niek Otten

"Shinygaia" <Shinygaia@discussions.microsoft.com> wrote in message
news:0A7D79C6-02C8-4776-8B3B-923D5D3585A0@microsoft.com...
> *Knocks her head on the table*
>
> I COMPLETLY forgot about radian and worst of all I knew it!!! *sigh* So
> much
> time wasted on something as easy as that... what a shame!!! lol
>
> Thanks to all of you guys!
>
> "Shinygaia" wrote:
>
>> Hi,
>>
>> I work with Excel on this math report and the formula I typed in just
>> kept
>> not working properly. The results were all off. So I checked everything
>> very
>> carefully and found out why it didn't work. In need to calculate sin and
>> cos
>> so I typed =SIN(45) in one cell and =COS(45) in another cell just to
>> check if
>> it works and ... Surprise! I ended up with two different results instead
>> of
>> 0,707 for both!!! I tried with =SIN(0), =SIN(180) and =SIN(360) and again
>> ...
>> wrong (supposed to be "0" for all of them). If someone knows a way to fix
>> that, it would be of great help!
>>
>> By the way, Happy Valentine Day!
>>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1