View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default 12th root of two

One way:

Function sqrtx12()
Dim i As Integer
sqrtx12 = 2
For i = 1 To 12
sqrtx12 = Sqr(sqrtx12)
Next
End Function

Called by: = sqrtx12()

Regards

Trevor


"ksnapp " wrote in message
...
hi,

i need a udf or nested function that will give me the 12th root of 2.
This value is important for music stuff and I could use a udf that give
it to me exactly.


thanks


---
Message posted from http://www.ExcelForum.com/