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 > > ------------------------------------------------------------------- >-- 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]
