If you click into the formula cell after it has been created, you will see the actual formula displayed in the Formula Bar and the answer displayed in the worksheet. The actual content of the cell will be the formula, but the cell will display the answer to the formula. Once again, this is the concept of “content versus display” at wok. When you are finished, exit the cell to display the answer to the formula that you wrote. To write a formula, first click into the cell where you want the results of the formula to appear. You use the ranged syntax to perform a single mathematical function over multiple cells. Typically, you will use the simple syntax to perform multiple mathematical calculations on multiple cells. It is important to note that these two syntaxes are not mutually exclusive! In fact, your more complex formulas will often incorporate elements of both in order to arrive at the desired result. There are two basic ways of writing formulas available: “ranged syntax” or “simple syntax.” A “syntax” is simply a way of expressing or writing something. You use formulas to perform mathematical functions on cells.
0 Comments
Leave a Reply. |