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 > > -- View this message in context: http://www.nabble.com/Excel-formula-tf3206097.html#a8923738 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
