Excel Functions in EAC ToolsExcel Functions in EAC Tools\Commutation functionsCommutation functions\Lx, Px, Qx

Lx, Px, Qx

Lx, Px, Qx return a mortality table value at age 𝑥. These functions all share the same syntax:

Syntax

Lx(Age, MortalityTable, [AgeSetback], [IssueAge])
Px(Age, MortalityTable, [AgeSetback], [IssueAge])
Qx(Age, MortalityTable, [AgeSetback], [IssueAge])

Parameter Name

Description

Age

Current age 𝑥.

MortalityTable

Mortality table definition text string.

Setback

Mortality table age set-back. A negative number is a set-forward.
Note that you can also define a setback using the "/sb" option in the table definition (or "/sf").
Optional, default = 0.

IssueAge

If using generational mortality projection, age at issue.
Optional, default = Age.