Thread: Pi in VBA?
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Prof Wonmug Prof Wonmug is offline
external usenet poster
 
Posts: 61
Default Pi in VBA?

On Tue, 28 Apr 2009 07:12:12 -0700, Jim Thomlinson
wrote:

I like that one... I would never have thought to use the ArcTangent but it
makes sense. I guess that is why they pay you the big money. That being said
I would be inclined to just use the constant and avoid the overhead of a
function.


You mean the 10 ns overhead (or whatever it is)?

If the function call is in a tight loop that is called billions of
times and if the function call (to define the constant) cannot be
moved outside the loop, then maybe.

Why calculate a constant?


Accuracy, portability, compatibility?