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]

Reply via email to