wholebad.blogg.se

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.