| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create arcTan function
Hello, How can I create a ARCTAN (TAN-1) function in VBA? Thank -- Tadashi ----------------------------------------------------------------------- Tadashii's Profile: http://www.excelforum.com/member.php...fo&userid=2391 View this thread: http://www.excelforum.com/showthread.php?threadid=50167 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create arcTan function
ATAN()
Tadashii wrote: Hello, How can I create a ARCTAN (TAN-1) function in VBA? Thanks -- Tadashii ------------------------------------------------------------------------ Tadashii's Profile: http://www.excelforum.com/member.php...o&userid=23918 View this thread: http://www.excelforum.com/showthread...hreadid=501675 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create arcTan function
Tadashii,
In the VB editor goto help and type in Derived and goto Derived Math Function. There is a list of useful equations. For arc or cotangent you could do the following. Public Function Arctangent(dblValue as Double) As Double Arctangent = 1# / Tan(dblValue) End Function Then in your code to call Arctangent. dblATan = Arctangent(dblValue) *** Sent via Developersdex http://www.developersdex.com *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create arcTan function
Use the built in Arttan function??
from Excel VBA help: Atn Function Returns a Double specifying the arctangent of a number. ---------------------------------------------- See help for details -- Regards, Tom Ogilvy "Tadashii" wrote in message ... Hello, How can I create a ARCTAN (TAN-1) function in VBA? Thanks -- Tadashii ------------------------------------------------------------------------ Tadashii's Profile: http://www.excelforum.com/member.php...o&userid=23918 View this thread: http://www.excelforum.com/showthread...hreadid=501675 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create arcTan function
thanks for the info -- Tadashii ------------------------------------------------------------------------ Tadashii's Profile: http://www.excelforum.com/member.php...o&userid=23918 View this thread: http://www.excelforum.com/showthread...hreadid=501675 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to find the arctan of an angle in Excel or an add . | New Users to Excel | |||
| do you know how i can find the f(x) of the arctan? | Excel Worksheet Functions | |||
| How do I create a function into function list? | Excel Programming | |||
| What function would I create? | Excel Worksheet Functions | |||
| where or how do i create a function that ive been given? | Excel Programming | |||
![Tadashii[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
