Quick Links
Home
. . Introduction
. . Why Business Functions
. . Whats New
. . For Property People
. . . . Why For Property
. . . . PCS Seminar
. . Why Free
. . Awards
. . Key Users
. . Forum
. . Excel 12
Products
. . Overview
. . Business Functions
. . . . Summary
. . . . Function Selector
. . . . Function Finder
. . . . Trace
. . . . Help
. . . . Function Examples
. . . . Tutorials
. . . . Monte Carlo
. . . . GoalSeek
. . . . Utilities
. . . . Callable from VBA
. . . . Array Functions
. . . . CashFlow Administrator
. . . . Select Function
. . . . Number Formats
. . . . Functions Overview
. . CashFlow Administrator
. . SelectFunction
. . NumberFormats
Services
. . Services Overview
. . Bespoke Model Development
. . Implementation Assistance
. . Custom Editions
Download
Reference
. . Function Categories
. . Function Families
. . Data Types
. . Variables
. . Topics
. . Features
. . Version History
. . Technical
Forum
Templates
. . Templates Home
. . Loans
. . Interest Rates
. . Finance
. . Budgeting
. . Math and Stats
. . Dates
. . Accounting
. . Real Estate
. . Real Estate (UK Specific)
. . Petroleum Economics
. . Techniques
. . Non Business Functions
Resources
. . Resources
. . Bookshop
. . Support
. . Tips & Articles
. . . . Tips
. . . . Business Functions
. . . . Excel
Company
. . Company
:: Reference
:: Features
Home
Introduction
Why Business Functions
Whats New
For Property People
Why Free
Awards
Key Users
Forum
Excel 12
Products
Overview
Business Functions
CashFlow Administrator
SelectFunction
NumberFormats
Services
Services Overview
Bespoke Model Development
Implementation Assistance
Custom Editions
Download
Reference
Function Categories
Function Families
Data Types
Variables
Topics
Features
Version History
Technical
Forum
Templates
Templates Home
Loans
Interest Rates
Finance
Budgeting
Math and Stats
Dates
Accounting
Real Estate
Real Estate (UK Specific)
Petroleum Economics
Techniques
Non Business Functions
Resources
Resources
Bookshop
Support
Tips & Articles
Forum
Company
Function Categories
Function Families
Data Types
Variables
Topics
Features
Version History
Technical
[Categories]
[Families]
[Data Types]
[Variables]
[Topics]
'Features' found in functions
This helps explain what the function names mean.
Market Zero-Aware
Market Zero-Aware
...I
Investment
...C
Capitalisation
Next...
Next Date
PV..
Present Value
Tot..
Total
Prev...
Previous Date
Multi..
Multiple Function
Ann ...
Simplified version of the function based upon annual calculations
F...
Rates pertain to the time
after
each corresponding
from
date
T...
Rates pertain to the time
up until
each corresponding
to
date
...Rev...
Revenue
...Grow...
Incorporating growth rates
...Fcst...
Changes are read of a supplied forecast.
...Pmt...
Payment
...Pmts...
Payments
Step...
Has a stepped rate profile
...Spread...
Time Spread
...A...
Average
Compatibility
Compatible with the Blib Library
...Collar...
The function is restrained to a maximum and a minimum
...Lim...
The function will return values until a cumulative limits reached
Unary
Unary Value ( ie value of $1)
...Per...
Periodic
...Lag...
Lag
...Seq...
Using Date Sequence
...TD
Time Dependent
...S
Seasonal
...Combine
Combine
...Mkt...
The function reviews to a market estimate at intervals
...SF
Incorporating a overall start and finish date
...Q
Quick (Simplified) version of a more complex function (see "See Also")
...BD
Business Days
...T
Data is supplied at specific times
...Levels...
Levels
...R
Function permits itself to repeat at time intervals.
..X
Extended
...BF
BF version of an Excel function
...G
General
...D
Date
...DCF
DCF
...Idx...
Changes in line with a supplied Index
...EM
External (Extra) Loan Margin
G...
Generic
...Reg...
Regular Expression
...Group
...Group
Any comments on this documentation? Send us your suggestions below.
Your Email Address (required)
Subject
Message
153