|
![]() |
![]() |
Entering formulas In this subsection we will enter some formulas. Formulas are algebraic statements that can be evaluated by Mesa to return a value in a cell. The formula in one cell can refer to the value in another cell. When the value in a cell changes, the spreadsheet automatically recalculates and updates each cell that relies on a value that was changed. To enter the formulas that calculate the balance in the SampleCompany account. Move to cell B11 and enter the formula =B8+B9 and press enter. This formula adds two values and places the result in cell B11. Next go to menu Range->Fill->SmartFill to fill ranges with sequences of data. Select the cell containing the data you want to start the sequence with, and Drag to all the cells you want to copy the data into. Then use the appropriate Range->Fill->SmartFill command to paste the data in. In our example we want to copy the data into cells for the next six months. You can use formulas to refer to cells in other worksheets. You can either use the mouse to 'click and select' the sheet and cells you want, or simply type the full cell reference yourself. To refer to a cell on a different worksheet, put the sheet name and a '!' (bang) before the cell reference. For example: ="Japan"!A23*25% ="Japan"!A23+"Germany"!A23+"USA"!A23 If you change the name of a worksheet, all formulas referring to that sheet will automatically update and use the new name. To show this, first copy and paste everything in 'Japan' to 'Germany' and again to 'Consolidation'. Next in 'Consolidation' go to B5 and type in '=' and then click to 'Japan B5, press 't' and click to 'Germany' B5. See also:
|
||
|
||