View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mark[_17_] Mark[_17_] is offline
external usenet poster
 
Posts: 95
Default trigonometric function

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


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

-----Original Message-----
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.



--
Regards,
Tom Ogilvy

"Mark" wrote in message
...
Anyone knows how to write in VBA following function:

sin^2
(0,5) 1/2
Regards
Mark


.



.