On Wed, 2005-04-06 at 04:43 -0700, Dale Stanchfield wrote: > On Wed, 2005-04-06 at 21:28 +1000, Brian wrote: > > Dale Stanchfield wrote: > > > > >I am trying to do simple calculations in a spread sheet. > > >Example: > > >Colume A is the number of shares. > > >Column B is the buying price. > > >Column C is the brokers commission. > > >Column D is the cost basis or total cost of buying the stock. > > >I would like to insert the values in columns A, B, and C and have the > > >program calculate the value of column D. > > >In other words, A *B+C=D. My problem is I can't seem to find the proper > > >format to type into the formula bar. I have spent hours looking in the > > >help sections, but I am getting nowhere. I would appreciate any help. > > > > > > > > All formulae start with an = sign, so if your data starts in row 4, > > then in cell D4 type =(A4*B4)+C4 and opress enter. > > Do this for all the other result cells (column D), changing the row > > numbers, ie, A5, A6, A7, etc > > It's the same as in Excel if you have used that > > > > Brian > > Thank you Brian. I was trying to do the whole thing with one formula. > I haven't used Excel. Can't afford it. > So, if I have 500 rows, I need to insert the formula 500 times? Do I > have that right? Seems like there should be a simpler way. But, you've > helped me a lot!\ > Thanks again, > stanch
Have you tried the duplication feature? Click on the first cell containing your formula. Notice there is a small black square in the bottom right corner. Click on this square and drag it down the column until you have all of your data covered. For more information on this and other OOo features, see http://tinyurl.com/5u8bt for the user guide. -- PLEASE KEEP MESSAGES ON THE LIST. Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
