Thx
Copied your formula into spreadsheet get error 501
It seems I2 is higher than 20 does not calculate
Ferencz
----- Original Message -----
From: "Dan Lewis" <[EMAIL PROTECTED]>
To: <[email protected]>; "Ferencz" <[EMAIL PROTECTED]>
Sent: 12 February, 2007 16:11
Subject: Re: [users] Excel formula
On Monday February 12 2007 6:59 am, TerryJ wrote:
Your formula (as Dan Lewis indicated) should be:
=ROUND(H5*$I$3+H5;$I$2)
Cheers.
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 )
>>
>> SUM format should be SUM(BEGINNING CELL:ENDING CELL) which does
>> not seem to be what you want. You seem to want to multiply cell
>> H5 with I3 then add H5 to that product. If so, that would simply
>> be (H5*$I$3 +H5).
>>
>>> Ferencz wrote:
>>> > Openoffice ver 2.1
>>> > xp pro
>>> >
>>> > I have an excel formula =ROUND(SUM(H5*$I$3+H5),$I$2) which
>>> > openoffice calc can't intrepert can someone help
>>> >
>>> > Thx
Copy sent to Ferencz
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
