On Monday February 12 2007 11:36 pm, Ferencz wrote:
> Thx
>
> Copied your formula into spreadsheet get error 501
> It seems I2 is higher than 20 does not calculate
>
> Ferencz
As stated below the format for ROUND IS
=ROUND( NUMBER; NUMBER OF DECIMAL PLACES). Do any of your entries have
more than 20 decimal places? Or perhaps more to the point, what is
the largest number of significant digits in your entries?
Dan
> ----- Original Message -----
> From: "Dan Lewis" <[EMAIL PROTECTED]>
> To: <users@openoffice.org>; "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: <users@openoffice.org>
> >> > 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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
