Relative: Difference between revisions
imported>Doug Williamson (Classify page.) |
imported>Doug Williamson (Add definition. Source: Linked pages) |
||
| Line 1: | Line 1: | ||
1. ''Measurement.'' | |||
A relative measure is one expressed as a proportion or percentage, rather than in money terms or other fixed terms. | A relative measure is one expressed as a proportion or percentage, rather than in money terms or other fixed terms. | ||
2. ''Financial modelling - spreadsheets - construction - cell references.'' | |||
In financial modelling with spreadsheets, relative refers to cell references when they're copied around the spreadsheet. | |||
An example of a relative cell reference in Excel is '''A1.''' | |||
When a relative cell reference is copied to other parts of the spreadsheet it will change in such a way as to maintain the ''relative'' difference in the positions of the referenced cell, and the cell pointing to it. | |||
Relative cell references are the default. | |||
By contrast, fully absolute cell references - for example '''$A$1''' in Excel - will stay as $A$1 wherever we copy them around to within the spreadsheet. | |||
== See also == | == See also == | ||
* [[Absolute]] | * [[Absolute]] | ||
* [[Default]] | |||
* [[Excel]] | |||
* [[Financial modelling]] | |||
* [[Spreadsheet]] | |||
[[Category:The_business_context]] | [[Category:The_business_context]] | ||
| Line 10: | Line 31: | ||
[[Category:Risk_frameworks]] | [[Category:Risk_frameworks]] | ||
[[Category:Risk_reporting]] | [[Category:Risk_reporting]] | ||
[[Category:Technology]] | |||
Revision as of 05:53, 2 February 2022
1. Measurement.
A relative measure is one expressed as a proportion or percentage, rather than in money terms or other fixed terms.
2. Financial modelling - spreadsheets - construction - cell references.
In financial modelling with spreadsheets, relative refers to cell references when they're copied around the spreadsheet.
An example of a relative cell reference in Excel is A1.
When a relative cell reference is copied to other parts of the spreadsheet it will change in such a way as to maintain the relative difference in the positions of the referenced cell, and the cell pointing to it.
Relative cell references are the default.
By contrast, fully absolute cell references - for example $A$1 in Excel - will stay as $A$1 wherever we copy them around to within the spreadsheet.
