GETCATYPE

Returns the numeric value of the TYPE of a specified beneficiary, as follows:

  • 0: Unknown/No Spouse
  • 1: Spouse
  • 2: Ex-spouse
  • 3: Child
  • 4: Other
Formula Syntax

GETCATYPE(Index)

Index: enter 0 here to get the TYPE of the beneficiary that was chosen when running the calculation or export. Otherwise, enter an index of 1-5 to get the corresponding type of the specified beneficiary.

Examples

GETCATYPE(3) returns TYPE of the third beneficiary stored in the person's record

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com