At 15:48 14/12/2008 -0800, C Y Augin wrote:
Using OO 2.4 in Windows 2k.
This works:
function GROWTH()
GROWTH = "test"
end function
In calc, I put =GROWTH() in a cell and it says "test" as expected.
This doesn't work:
function GROWTH(happy)
GROWTH = "test"
end function
In calc, I put =GROWTH(J52) in a cell and it says #VALUE. J52 is a
cell containing an integer value.
The only thing that has changed is the presence of an argument, but
the value isn't even used. Therefore I'm stumped as it seems like I
simply cannot have arguments in my function. Probably I am making
some newbie mistake. I have tried following tutorials and I do not
see how my code is any different from theirs.
One obvious problem is that there exists a built-in (array) function
in Calc called "GROWTH" ("Calculates the points of an exponential
trend in an array"). What happens if you choose an alternative name
for your function?
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
