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]
