On Saturday 10 Feb 2007, Ferencz wrote (regarding [users] Excel formula): > 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
Hi Ferencz (not sure if that is the right way of addressing you, but I have no other choice...), In addition to what Joe Conner (<[EMAIL PROTECTED]>), and others, have mentioned, here is some stuff: a. I presume that you have the number of decimal places in $I$2 (say, 3) b. I presume that this is probably a method of getting "x" percent more (or less) than the value in H5. c. I also presume that you have that percentage (step b above) in cell $I$3 (say, 20%) You are doing everything right - as Joe mentioned, replace the "," (comma) with a ";" (semicolon) in the formula. BTW, if my assumptions (a) to (c) above are right, it probably would be simpler to use something like =round(H5 * (1+$I$3), $I$2) Please pardon a personal question - I am an Indian, and am interested in knowing how you pronounce your name. If you will not take offense, may I request you to please email the pronunciation personally to my ID, as this question is not relevant to the list (rest of the list, my apologies) -- Pradeep Srinivas Bangalore, India --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
