A Calc cell can only contain a limited number of digits - IIRC, it's about 15 or 16. You will have to reduce the number in I2 accordingly.
Dan Lewis wrote: > > 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] > > > -- View this message in context: http://www.nabble.com/Excel-formula-tf3206097.html#a8955422 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
