Absolute

1.

An absolute measure is one expressed in money terms or other fixed terms, rather than a proportion or percentage.

2.

Outright, without limit or qualification.

3. Financial modelling - spreadsheets - construction - cell references.

In financial modelling with spreadsheets, absolute refers to cell references when they're copied around the spreadsheet.

Fully absolute cell references - for example $A$1 in Excel - will stay as $A$1 wherever we copy them within the spreadsheet.

This kind of cell reference is sometimes known as an anchored, fixed or dollarised reference.

Contrasted with a standard relative cell reference - for example A1.

Relative cell references are the default.

See also

• Absolute emissions
• Absolute purchasing power parity
• Absolute zero
• Anchoring
• Default
• Excel
• Financial modelling
• Freehold
• Relative
• Spreadsheet