keme wrote:To tell Calc that you want a calculation, you start the cell entry with an equals sign. So if your data are in column B, in cell B5 you would enter =B2-(B3+B4).
HUH? These are rows.......
- Code: Select all Expand viewCollapse view
A B C D E
MIKE $20 $10 $5 I want this row to = B-(C+D)
john $15 $8 $1 again want total
and on and on and on
Also where am i supposed to enter the formula you posted?
OK, there's a clash in terminology here. Sorry!
In everyday language, a "row" could mean any set of objects arranged along a straight line.
In spreadsheet terms, we have a grid, that divides the sheet up into cells. Cells along a horizontal line, normally labeled with a number at left, constitute a row. Cells along a vertical line, often labeled by a letter (or letter combination) at the top, constitute a column. That's why I misunderstood your description of rows. I was bound by the terminology, whereas your setup is of course the logical (and most common) one.
If you start in row 2 (using row 1 for headings), then you enter this formula in cell E2: =B2-(C2+D2)
Copy that formula to the next cell in column E, and you'll see that the row numbers of the cell references update accordingly.
Apache OO 3.4.1/4.1.2, on Ms Windows 7/10 and Mac OS-X. LibreOffice 22.214.171.124 on Mepis Antix MX