SIN and COS Functions

[Adrian Garza]

I am having trouble with the SIN and COS fuinctions for a simple formula

SIN(H3)*f3 And COS(H3)*f3

I have done the operation by hand and got a diffrent answer, used two
calculators and tresult in excell is not correct. Is there a fix? Or should
i do evreything by hand?


H3= 247.77111
Excel = SIN (247.77111)= .402923 COS (247.77111)=-0.91523
HP32SII= SIN(247.77111)= -0.9257 COS (247.77111)= -0.3783

Have a lot of data to run it all by hand, is there any fix?

Thanks in advance

 

[JE McGimpsey]

I am having trouble with the SIN and COS fuinctions for a simple formula

SIN(H3)*f3 And COS(H3)*f3

I have done the operation by hand and got a diffrent answer, used two
calculators and tresult in excell is not correct. Is there a fix? Or should
i do evreything by hand?


H3= 247.77111
Excel = SIN (247.77111)= .402923 COS (247.77111)=-0.91523
HP32SII= SIN(247.77111)= -0.9257 COS (247.77111)= -0.3783

Have a lot of data to run it all by hand, is there any fix?

Your results are correct (though I suspect H3 is calculated, because

=SIN(247.77111) = 0.402924194355002

which rounds to 0.402924).

As stated in XL Help, XL's trig functions operate in Radians, not
Degreees. Specifically the SIN function descriptions tell you how to
convert degrees to radians (the COS function does too, but it has an
error):

If your argument is in degrees, multiply it by PI()/180 or use the RADIANS
function to convert it to radians.

So

=SIN(RADIANS(247.77111)) = -0.925679950114457

and

=SIN(H3*(PI()/180)) = -0.925679950114457

Note: If you don't enclose the (PI()/180) in parens, the last digit will
be 6 rather than 7 due to internal rounding.

 

[JPvC]

Hello,
Do you know the difference between degrees and radians ?
In Excel, trigonometric calculations are performed on numbers expressed
in radians. If H3 is expressed in degrees, you have to multiply it by
PI/180 to get the right answer.
You are welcome.
JPvC

Adrian Garza a écrit :