Business Glossary
SEARCH THE BUSINESS GLOSSARY
Business Definition for: relative address
relative address
- in computer memory, a memory address measured relative to another location. To convert a relative address into an absolute (true) address it is necessary to add the address of the point it is measured from. Compare offset .
- in a spreadsheet program, a cell address that indicates the position of a cell relative to another cell. If this formula is copied to another location, the address will be changed so that it refers to the cell in the same position relative to the new cell. In Lotus 1-2-3 and Microsoft Excel, a cell address is treated as a relative address unless it contains dollar signs. (See absolute address .) For example, if the formula 2*D7 is entered into the cell E9, the D7 in the formula really means, "the cell that is one column to the left and two rows above." If this formula is now copied to cell H15, the formula will now become 2*G13, since G13 is the cell that is one column to the left and two rows above the cell H15.
Copyright © 2006, 2003, 2000, 1998, 1996, 1995, 1992, 1989, 1986 by Barron's Educational Series, Inc. Reprinted by arrangement with Publisher.
