Absolute: Difference between revisions
From ACT Wiki
Jump to navigationJump to search
imported>Doug Williamson m (Add category.) |
imported>Doug Williamson (Add definition. Source: Linked pages) |
||
| Line 7: | Line 7: | ||
Outright, without limit or qualification. | 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 around to 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 == | == See also == | ||
* [[Default]] | |||
* [[Excel]] | |||
* [[Financial modelling]] | |||
* [[Freehold]] | * [[Freehold]] | ||
* [[Relative]] | * [[Relative]] | ||
* [[Spreadsheet]] | |||
[[Category:The_business_context]] | [[Category:The_business_context]] | ||
[[Category:Technology]] | |||
Revision as of 05:46, 2 February 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 around to 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.
