Databases Reference
In-Depth Information
FIGURE 4.2
A simple times table.
In this particular case, each cell in column E that is to hold an answer would have a formula like this:
=A[row]*C[row]
where [row] is equal to the row number. For example, the formula in row 1 would be the text string:
=
A1*C1
Formulas are in fact text strings and can be written into any particular cell as such. Every
formula must begin with the “
” sign!
Note: Functions attached to cells are also referred to as formulas. When a mathematical expression
is attached to a Worksheet cell, it can be called either a function or a formula. The terms are
utilized interchangeably in this chapter. Oddly enough, when attaching a function to a cell, the
property,
=
Formula is utilized. Yet, when the formula wizard appears, and a formula is to be
selected, the notation “More Functions …” is utilized to allow the user access to a GUI that
shows all the available formulas, but the GUI is titled “Paste Function” (see Figure 4.4). This is
very confusing.
The following subroutine will add any formula to any cell. How can one determine what the
text string should be for a particular formula? Simply click on the cell that is to utilize the formula
and then click on the “
=
” button on the formula bar as illustrated in Figure 4.3.
FIGURE 4.3
Determining the proper formula syntax.
