EACInfo returns an explanation of the referenced EAC function. Various elements of the function can be returned, e.g. a description of the mortality table that was specified, or a detailed explanation of the type of annuity that was specified.
For example: if the function PVSL12
is in cell B11, then the function call EACInfo (“B11”,”all”) in cell A12 will
return the following text that spills from A12 to A17.
|
Note: |
Currently the EACInfo function works only for a small collection of EAC functions. More functions will be added in future versions of EAC Tools. AE, AESLTOCL, AESLTOJL, AESLTOLI, AgeOfSurvival, DecrLifeIns, DecrLifeInsJL, DecrLifeInsPPA, EAAD, EAADPPA, PVSL, LifeExpect, LifeExpectJL, LifeExpectPPA, LifeIns, LifeInsJL, LifeInsPPA, ProbSurvival, ProbSurvivalPPA, PVCO, PVCOPPA, PVJL, PVJL12, PVJLGAM83, PVJLGATT2003, PVJLPPA, PVJLUP84, PVJLX, PVSL, PVSL12, PVSLGAM83, PVSLGATT2003, PVSLLI, PVSLPBGC, PVSLPPA, PVSLUP84 |
Syntax
EACInfo (reference, [info_type])
|
Parameter Name |
Description |
||||||||||||||||||||||
|
reference |
A text string containing the address of the cell that you want information about. If the text string is “version” instead of a cell address, then the EAC version is returned (and the info_type is not used) |
||||||||||||||||||||||
|
info_type |
A text value that specifies what type of function information you want to return. The following list shows the possible values of the info_type argument and the corresponding results. Optional, default = “all”.
|