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 giv
it to me exactly.


thank

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

Hi
try
=2^(1/12)


--
Regards
Frank Kabel
Frankfurt, Germany


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/

Why do you need nested functions. 12th root of 2 is just 2^(1/12), so your
UDF just needs

Function NthRoothOf2(Root as Long)
NthRootOf2 = 2^(1/Root)
End Function

The accuracy will be limited by Excel's FPA engine.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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/

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/

Should have said that call with

=NthRootOf2(12)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bob Phillips" wrote in message
...
Why do you need nested functions. 12th root of 2 is just 2^(1/12), so your
UDF just needs

Function NthRoothOf2(Root as Long)
NthRootOf2 = 2^(1/Root)
End Function

The accuracy will be limited by Excel's FPA engine.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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/

UDF not needed. Enter formula into a cell:
=2^1/12

(Set the value of the cell to 2 raised to the 1/12th power. This is a
one-time calculation, unless you can define the problem a bit more.)

--
Regards,
Bill


"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/

We know, but he asked for a UDF, so we gave him one.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bill Renaud" wrote in message
...
UDF not needed. Enter formula into a cell:
=2^1/12

(Set the value of the cell to 2 raised to the 1/12th power. This is a
one-time calculation, unless you can define the problem a bit more.)

--
Regards,
Bill


"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/