I have some data on gas mileage of my car. I would like to move it from paper to a spreadsheet. if I could do it recursively …a1{some operation}b1 = c1 … then… a2{same operation}b2 = c2 etc. etc. I would have to manually enter less data from my paper records. The car has an avg mpg meter also so I have been keeping track of actual vs. reported m/g. So in
general I need … cell{function}cell =cell … for each cell in a column. I really have looked in various tutorials for this but I can’t find it.
P.S. does anyone know of a good book on libreoffice calc. Thanks in advance to any who can help.
If you enter the formula =A1/B1 into the cell C1 and you want to apply the respective formula also in the second row, you can simply copy it and paste it into C2. The cell addresses you used are relative and will adapt automatically.
You can also fill down the formula dragging the little handle with the mouse. If no adaption is wanted, you need to use absolute addressing regarding the rows (and also in the column part where applicable). Relative vs absolut addressing and Copy/Paste/Fill is surely discussed in any introduction to spreadsheets.
Concerning the rounding there are basically two aspects: The value and the format it is displayed in.
To get the rounded result in your case you can use =ROUND(A1/B1;2) where the “2” gives the number of decimal places.
If you want the value itself unchanged, but displayed only with 2 decimal places, set the ‘Numbers’ format for the respective cells to the code 0.00 .
If you want the results rounded by formula without the cancellation of trailing zeros, you also need this format.
thanks, copy-paste worked … I dint see any little handle to drag. Also couldn’t get round to work. I entered a semicolon like you showed but in the place where it shows what formula is in the cell it somehow was getting changed to a comma??? I just changed the numbers format to 2 dec places
The semicolon I used in the little formula is the delimiter between the two parameter positions of the ROUND() function. It is still accepted globally (under any locale setting), but in recent versions of LibO Calc it is replaced by a comma for the display. In locales using the comma as the decimal separator it cannot also be used to delimit parameters because of the obvious conflict concerning numeric constants.
In this international forum I therefore prefer the semicolon.
The fill handle is the tiny square at the right bottom of the cell you are working with. You can seize it with the left mouse button and then dragg it moving the mouse with the ‘Fill’ functionality till you release the button.
OK, I see it now. Thanks so much, I will make some notes on this.