Microsoft Office Tutorials and References
In Depth Information
Relative and Absolute Addressing
This time it is different. If we use the same procedure described above, we could
calculate the tax in cell F3, namely multiply E3 by G1 and transfer/drag the formula
to the rest of the cells in the column
column F. If you use the same procedure, you
will run into a problem. Since Excel is using the
concept, it will
multiply F3 by G2, F4 by G3, and so on. G1 is the only cell that contains the tax rate
relative addressing
FIGURE 3.4 Cell G1 Has to Have Absolute Addressing
FIGURE 3.5 Cells F4 to F10 Resulted in Zero
Search JabSto ::




Custom Search