This is important, because the best way to build formulas is to use parentheses to set off parts of the formula. Next, you see an expression inside of parentheses. Would work just as well, though you should expect that the next time you look at this Calc will probably have turned it back to all upper case. Calc will work with them fine if they are lower case, or even if some are lower and some are upper. Actually, all of the letters we see here are upper case, but it doesn’t really matter. Second, it contains the formula name of SUM. First, it begins with an equals sign, which is telling Calc to perform a calculation. I will adjust my formula to just go to cell B13, though, just to prevent any future problems. Since cell B14 is empty, it won’t matter. Well, actually it will probably read =SUM(B2:B14) because LibreOffice assumes I want to sum everything. When you do this the Formula bar will now show you what is in cell B15 (as I did it) and it will read: I like to skip a line when getting sums because it makes the spreadsheet easier to read, and Calc takes this in stride.

B15), click on the Sum symbol, and Calc would guess that what you wanted to do was add up those numbers and place the total in the cell. If you had a column of numbers, say in Column B, that were in cells B2 through B13 inclusive, you could then go to cell B14, or even lower (e.g. One of the things you do often in a spreadsheet is add up bunch of numbers. The next Icon is a Greek upper-case sigma, which is the mathematical symbol for a _sum_. BTW, the script “f” is the mathematical symbol for function, hence the icon. Since Functions will be worth many tutorials in themselves we won’t spend any time on this right now other than to note this is where you access all of the built-in mathematical functions that Calc offers.

Next to this is an icon for the script “f” and a magic wand image. C12), press the Enter key, and you will move to that cell and can start editing. But it also can move you to a different cell.

First, there is what is called a Name Box, which displays the cell address of the cell you are editing. This place is the best place to work with Formulas, and has several features worth mentioning.

Excel libre office