Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help on UDF code
I have the following code to create a UDF to calculate reciprocals:
Function Reciprocal(a) Reciprocal(a) = (1 / a) End Function The code is in a module. I get #VALUE! errors when I try to run it. So I think this means that Excel recognizes the UDF (otherwise it would return a #NAME error, right?) So what's the problem here? -- Brevity is the soul of wit. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
help on UDF code
Avoid the appearance of recursion:
Function Reciprocal(a) Reciprocal = (1 / a) End Function -- Gary''s Student "Dave F" wrote: I have the following code to create a UDF to calculate reciprocals: Function Reciprocal(a) Reciprocal(a) = (1 / a) End Function The code is in a module. I get #VALUE! errors when I try to run it. So I think this means that Excel recognizes the UDF (otherwise it would return a #NAME error, right?) So what's the problem here? -- Brevity is the soul of wit. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
help on UDF code
OK, that works, thanks.
What do you mean by the appearance of recursion? -- Brevity is the soul of wit. "Gary''s Student" wrote: Avoid the appearance of recursion: Function Reciprocal(a) Reciprocal = (1 / a) End Function -- Gary''s Student "Dave F" wrote: I have the following code to create a UDF to calculate reciprocals: Function Reciprocal(a) Reciprocal(a) = (1 / a) End Function The code is in a module. I get #VALUE! errors when I try to run it. So I think this means that Excel recognizes the UDF (otherwise it would return a #NAME error, right?) So what's the problem here? -- Brevity is the soul of wit. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
help on UDF code
There are some functions that are actually defined in term of themselves.
Factorials or Ackerman's function for example. See: http://www.nist.gov/dads/HTML/ackermann.html -- Gary's Student "Dave F" wrote: OK, that works, thanks. What do you mean by the appearance of recursion? -- Brevity is the soul of wit. "Gary''s Student" wrote: Avoid the appearance of recursion: Function Reciprocal(a) Reciprocal = (1 / a) End Function -- Gary''s Student "Dave F" wrote: I have the following code to create a UDF to calculate reciprocals: Function Reciprocal(a) Reciprocal(a) = (1 / a) End Function The code is in a module. I get #VALUE! errors when I try to run it. So I think this means that Excel recognizes the UDF (otherwise it would return a #NAME error, right?) So what's the problem here? -- Brevity is the soul of wit. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Questions | New Users to Excel | |||
code not unique find latest date | Excel Discussion (Misc queries) | |||
VLOOKUP for Zip Code Ranges | Excel Worksheet Functions | |||
Conform a total to a list of results? | Excel Discussion (Misc queries) | |||
Macro for changing text to Proper Case | Excel Worksheet Functions |