- Rate Projections Functions Walkthrough
- Accruals and Cash
- Repeating Formulae
- Range Names and References
- Optional Parameters
- Using PmtsPerYear
- Modelling Seasonality
- Calculating Interest
- Using Business Functions in VBA (Visual Basic for Applications)
- Array Functions
- Volatility
- Annual Equivalent Rates
- Array Function
- Auto Multi Functions
- Variable Plurality
- GoalSeek
- CELL
- INDIRECT
- INFO
- NOW
- OFFSET
- RAND
- RANDBETWEEN
- RTD
Volatility | |
Why some functions in Excel and BF re-calculate with more frequency than others | |
Volatile functions always recalculate when the worksheet is calculated, even if their inputs have not changed. Excel has some volatile functions: The reason functions are specified as volatile is because Excel has no means of knowing when to recalculate them because they are in some sense outside of the normal dependency chain. INDIRECT for example, as its name implies, only has an indirect link with its source date - the rangename. Random number functions don"t depend on anything, so the only safe thing to do is to generate a new random number every time the spreadsheet is recalculated. BF"s volatile functions are: The reason for the first two being volatile is that a reference may change without the target cell of the function actually having changed. The remainder of these functions need to volatile because a random number is involved, either simply returning a random number or using that number to go and sample a statistical distribution. |