Inverse tangents in Excel

[Shugster]

I'm having some trouble using the ARCTAN function in Excel.

(I'm trying to prove to myself that a concept I have come up with will work).

I can find and use it on the Excel sheet itself but I need to write a macro in the VB editor. The editor does not recognise the function so I assume I need to add / enable something? Any idea what it is exactly?

 

[shettie]

Have a butchers in excels /tools/addins - see whats ticked in there - I'll have a dig and see what I can find ARCTAN eh??

 

[P&A77TheB@stardCourse]

Does this help...?
http://www.pcreview.co.uk/forums/thread-2423857.php

 

[shettie]

This help?

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)

 

[Shugster]

Thanks for that.

I'll have a, "Butchers", when I get home tonight.
DT_Xtremez_26:

 

[Shugster]

This help?

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)

Off TopicYou seem quite up on this Shettie. What line are you in now?Off Topic

 

[shettie]

Off TopicYou seem quite up on this Shettie. What line are you in now?Off Topic

google IT support - I get a lot of requests to find out how to do stuff for users - just got lucky on this one!

 

[Tin basher]

This help?

In google goto help and type in images

Function. There is a list of useful functions select results filter off

For chebs or norks you could do the following.

type in chebs or norks As Double (2 are better than 1)

chebs = 1# / norksTan(boobies)

End Function

Then in your own time call for a tissue.

DT_Xtremez_30:

With apologies to shugster and shettie. TB

 

[shettie]

This help?

In google goto help and type in images

Function. There is a list of useful functions select results filter off

For chebs or norks you could do the following.

type in chebs or norks As Double (2 are better than 1)

chebs = 1# / norksTan(boobies)

End Function

Then in your own time call for a tissue.

DT_Xtremez_30:

With apologies to shugster and shettie. TB

No need to apologise TB - that makes perfect sense! Double Norks Hmmm...

 

[gemarriott]

I'm having some trouble using the ARCTAN function in Excel.

(I'm trying to prove to myself that a concept I have come up with will work).

I can find and use it on the Excel sheet itself but I need to write a macro in the VB editor. The editor does not recognise the function so I assume I need to add / enable something? Any idea what it is exactly?

well don't fcuking use it then!

 

[Shugster]

well don't fcuking use it then!

Well it was either that or use the Sine rule which I couldn't remember at the time and had no "Tinternet" connection, (Last week).

Thanks for your help anyway.
DT_Xtremez_30:

 

[gemarriott]

Well it was either that or use the Sine rule which I couldn't remember at the time and had no "Tinternet" connection, (Last week).

Thanks for your help anyway.
DT_Xtremez_30:

you're welcomeDT_Xtremez_14: