I created a formula in a table. Now how do I copy it down?

theneonwind · Newbie Joined: 09 May 2012 Posts: 1

OMG, I'm such a mess.

I'm going Crazy with this and it's probably something so simple.

I Created a Formula in the table: =<E1>*0.50

to take the dollar amount from <E1> and Multiply it by 50%

Does anyone know how I can copy that down all the rows so that I don't have to do each one by hand?

<E2>*0.50

<E3>*0.50

Etc

Also, if you know how to round the a column to the nearest 25 cents that would help too.

My heads hurts sooooo much. Pleas Help.

floris_v · Posted: Wed May 09, 2012 12:59 pm Post subject:

You should do such things in Calc. Formulas in Writer are rudimentary.
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum

JohnV · Posted: Wed May 09, 2012 1:02 pm Post subject:

Or you can insert a Calc object in Writer.
Insert > Object > OLE object > Spreadsheet.