Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SIN , COS , TAN VALUES NOT CORRECT.
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SIN , COS , TAN VALUES NOT CORRECT.
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 On Dec 2, 2:19*pm, HARSHAWARDHAN. S .SHASTRI wrote: * 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SIN , COS , TAN VALUES NOT CORRECT.
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 "HARSHAWARDHAN. S .SHASTRI" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match formula not returning correct values. | Excel Discussion (Misc queries) | |||
VLOOKUP won't generate correct response for "inbetween" values | Excel Discussion (Misc queries) | |||
Calculating correct pecentages with negative values | Excel Worksheet Functions | |||
show difference between weights with correct pos and neg values | Excel Worksheet Functions | |||
x axis not showing correct values | Charts and Charting in Excel |