Excel
uses two types of cell references to create formulas. Each has
its own purpose. Read on to determine which type of cell
reference to use for your formula.
Relative
Cell References
This
is the most widely used type of cell reference in formulas.
Relative cell references are basic cell references that adjust and
change when copied or when using AutoFill.
Example:
=SUM(B5:B8),
as shown below, changes to =SUM(C5:C8) when copied across to the
next cell.
Absolute
Cell References
Situations
arise in which the cell reference must remain the same when copied
or when using AutoFill. Dollar signs are used to hold a column
and/or row reference constant.
Example:
In
the example below, when calculating commissions for sales staff, you
would not want cell B10 to change when copying the formula down.
You want both the column and the row to remain the same to refer to
that exact cell. By using $B$10 in the formula, neither
changes when copied.
Notice: You have the author's
permission to use the tutorials on this site for your personal
use only. If you would like to use these tutorials for
training classes or other commercial use, please contact kstille@esmartweb.com.
Distribution in print or on the Web without the author's permission
is strictly prohibited.
Featured Sites
HandofGrace.com
Quality,
affordable sterling silver beaded bracelets & mothers
bracelets. Swarovski crystals, fresh water pearls, Venetian
glass and other unique findings are featured in our bracelets.
The perfect gift for any occasion!
BakedByMom.com
Offering homemade cookie and candy boxes or gifts at reasonable prices, Baked by Mom strives to provide the best quality product in it's class. Try the White Chocolate Chip & Lime cookies, Rocky Road Candy and Caramels - they get rave reviews!
