To enter a formula, type directly the formula into the cell or into the input line of the formula bar. Νow every time we update the value of one of the items, the total is dynamically calculated. When you type the formula and press enter the result again will be 30. Using formulas we can write the total in the previous example as =C3+C4+C5.
In a spreadsheet, the variables are cell locations that hold the data needed for the equation to be completed. Formulas are equations using numbers and variables to get a result. To handle this situation, we use a third type of data: the formula.
For example in a list of item prices, the total depends on each individual item price. In a spreadsheet often the contents of one cell depend on the contents of other cells.
0 kommentar(er)
