Business Definition for: absolute address
absolute address
- a fixed location in the computer's memory. See
computer architecture
;
offset
.
- in a spreadsheet program, a cell address that refers to a fixed location that will not change when a formula is copied to another location. In Lotus 1-2-3 and Excel, absolute addresses are indicated by placing a dollar sign before the column and row indicator. For example, if the formula 2*$D$7 is entered into a cell, then $D$7 is an absolute address. If this formula is copied to another cell, the address $D$7 will not change. Contrast
relative address
.
Copyright © 2006, 2003, 2000, 1998, 1996, 1995, 1992, 1989, 1986 by Barron's Educational Series, Inc. Reprinted by arrangement with Publisher.