Error 502 is for: "Function argument is not valid, for example, a
negative number for the root function." I suggest that you check the
cells used and insure that they pass the insanity test. In other words,
they are real values, not for example a string that looks like a number.
Ferencz wrote:
Thx
I have replaced the "," with ";" but still no result (get Err:502)
Ferencz
----- Original Message ----- From: "Dan Lewis" <[EMAIL PROTECTED]>
To: <[email protected]>
Cc: "Ferencz" <[EMAIL PROTECTED]>
Sent: 10 February, 2007 23:02
Subject: Re: [users] Excel formula
Comment in-line
On Saturday February 10 2007 12:27 pm, Joe Conner wrote:
Calc uses semicolons, not commas to separate parameters. I do not
understand what the formula does for you, but I do know that the
ROUND format should be ROUND( NUMBER ; DECIMAL PLACES )
<<SNIP>>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]