trigonometric function

[Mark]

Anyone knows how to write in VBA following function: sin^2
(0,5)> 1/2
Regards
Mark

 

[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.

 

[Mark]

I knew function sin. I meant about hiperbolic
function "sin^2". "Sinh" doesn't work..
Regards
Mark

 

[Tom Ogilvy]

? application.sinh(1)
1.1752011936438
? application.sinh(-1)
-1.1752011936438


agrees with the values in help.

 

[Mark]

Many thanks!!
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





.