Ask Your Question

How do I.... a1/b1=c1(round result to 2 places) then ..a2/b2=c2 without manually entering that in each c(x) cell [closed]

asked 2017-10-27 15:49:38 +0100

sam1951 gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by sam1951
close date 2017-10-28 16:09:34.657924

1 Answer

Sort by » oldest newest most voted

answered 2017-10-27 16:37:53 +0100

Lupp gravatar image

updated 2017-10-27 16:39:13 +0100

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.

edit flag offensive delete link more


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

sam1951 gravatar imagesam1951 ( 2017-10-27 17:39:38 +0100 )edit

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.

Lupp gravatar imageLupp ( 2017-10-27 17:48:54 +0100 )edit

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.

Lupp gravatar imageLupp ( 2017-10-27 17:52:49 +0100 )edit

OK, I see it now. Thanks so much, I will make some notes on this.

sam1951 gravatar imagesam1951 ( 2017-10-28 16:08:02 +0100 )edit

Question Tools

1 follower


Asked: 2017-10-27 15:49:38 +0100

Seen: 131 times

Last updated: Oct 27 '17