Re: SIN and COS Functions
From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 02/14/05
- Next message: JE McGimpsey: "Re: COS and SIN Problem"
- Previous message: Adrian Garza: "SIN and COS"
- In reply to: Adrian Garza: "SIN and COS Functions"
- Next in thread: JPvC: "Re: SIN and COS Functions"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 14 Feb 2005 15:29:17 -0700
In article <BE367C79.537C%aegarza@flash.net>,
Adrian Garza <aegarza@flash.net> wrote:
> 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.
- Next message: JE McGimpsey: "Re: COS and SIN Problem"
- Previous message: Adrian Garza: "SIN and COS"
- In reply to: Adrian Garza: "SIN and COS Functions"
- Next in thread: JPvC: "Re: SIN and COS Functions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
