Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
How come Excel can't calculate any =SIN(x) or =COS(y) correctly?
Excel uses radians--not degrees:
=SIN(RADIANS(45)) 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
How come Excel can't calculate any =SIN(x) or =COS(y) correctly?
In Excel, angles should be expressed in Radians, not degrees
=SIN(RADIANS(45))-COS(RADIANS(45)) returns (almost) zero -- Kind regards, Niek Otten "Shinygaia" wrote in message ... 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" wrote in message ... In Excel, angles should be expressed in Radians, not degrees =SIN(RADIANS(45))-COS(RADIANS(45)) returns (almost) zero -- Kind regards, Niek Otten "Shinygaia" wrote in message ... 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
How come Excel can't calculate any =SIN(x) or =COS(y) correctly?
:-}
-- Kind regards, Niek Otten "Shinygaia" wrote in message ... *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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel to Calculate All Combinations of a Set of Data? | Excel Worksheet Functions | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Is it possible to calculate integrals with Excel? | Excel Worksheet Functions | |||
How do I calculate the root of a number using Excel? | Excel Worksheet Functions | |||
how to calculate overtime automatically on Excel timesheets | Excel Worksheet Functions |