M
Mark
Anyone knows how to write in VBA following function: sin^2
(0,5)> 1/2
Regards
Mark
(0,5)> 1/2
Regards
Mark
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tom Ogilvy
Not sure what you want, but VBA has a built in SIN function - it takes
radians as an argument:
From help:
Sin Function
Returns a Double specifying the sine of an angle.
Syntax
Sin(number)
The required number argument is a Double or any valid numeric expression
that expresses an angle in radians.
Remarks
The Sin function takes an angle and returns the ratio of two sides of a
right triangle. The ratio is the length of the side opposite the angle
divided by the length of the hypotenuse.
The result lies in the range -1 to 1.
To convert degrees to radians, multiply degrees by pi/180. To convert
radians to degrees, multiply radians by 180/pi.
radians as an argument:
From help:
Sin Function
Returns a Double specifying the sine of an angle.
Syntax
Sin(number)
The required number argument is a Double or any valid numeric expression
that expresses an angle in radians.
Remarks
The Sin function takes an angle and returns the ratio of two sides of a
right triangle. The ratio is the length of the side opposite the angle
divided by the length of the hypotenuse.
The result lies in the range -1 to 1.
To convert degrees to radians, multiply degrees by pi/180. To convert
radians to degrees, multiply radians by 180/pi.
M
Mark
I knew function sin. I meant about hiperbolic
function "sin^2". "Sinh" doesn't work..
Regards
Mark
function "sin^2". "Sinh" doesn't work..
Regards
Mark
T
Tom Ogilvy
? application.sinh(1)
1.1752011936438
? application.sinh(-1)
-1.1752011936438
agrees with the values in help.
1.1752011936438
? application.sinh(-1)
-1.1752011936438
agrees with the values in help.
M
Mark
Many thanks!!
I omit object application in sinh.
I omit object application in sinh.
-----Original Message-----
? application.sinh(1)
1.1752011936438
? application.sinh(-1)
-1.1752011936438
agrees with the values in help.
--
Regards,
Tom Ogilvy
.