Excel - SIN , COS , TAN VALUES NOT CORRECT.

Asked By HARSHAWARDHANSSHASTR on 02-Dec-08 09:19 AM
I have one form in which I have added 2 text boxes. In text box 1 I am
putting angle values in degrees and in text box 2 I am looking for sin value
. Which formula should
I write in change event of textbox1 so that i will get sin value.




Pete_UK replied on 05-Dec-08 11:13 PM
Don't forget that the trigonometrical functions in Excel expect angles
to be in radians - check it out in Excel Help.

Hope this helps.

Pete

m
lue
ShaneDevenshir replied on 02-Dec-08 12:27 PM
Hi,

Use:
SIN(angle)
COS(angle)
TAN(angle)

All of these work in VBA as written above, however, they will fail if
written as

WorksheetFunction.Sin(angle)

or if the angle is in degrees not radians then convert to radians using

WorksheetFunction.Radians (22.5)

So your formulas might look like this

SIN(WorksheetFunction.Radians (22.5))

If this helps, please click the Yes button

Cheers,
Shane Devenshire