Absolute: Difference between revisions
From ACT Wiki
Jump to navigationJump to search
imported>Doug Williamson (Add definition. Source: Linked pages) |
imported>Doug Williamson (Add links.) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 13: | Line 13: | ||
In financial modelling with spreadsheets, absolute refers to cell references when they're copied around the spreadsheet. | 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 | Fully absolute cell references - for example '''$A$1''' in Excel - will stay as $A$1 wherever we copy them within the spreadsheet. | ||
| Line 24: | Line 24: | ||
== See also == | == See also == | ||
* [[Absolute emissions]] | |||
* [[Absolute purchasing power parity]] | |||
* [[Absolute zero]] | |||
* [[Anchoring]] | |||
* [[Default]] | * [[Default]] | ||
* [[Excel]] | * [[Excel]] | ||
Latest revision as of 16:41, 2 July 2022
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.
