Calc ID function

For a full list of available calculation functions, please read What calculation functions are supported.

This article describes the formula syntax and usage of the ID function.

Description

Returns values associated with a South African 13-digit ID number.

Syntax

ID(id_number, [return_value])

The ID function syntax has the following arguments:

• id_number - Required. The South African 13-digit ID number you want to evaluate.
• return_value - Optional. The value you want returned. If omitted, the function returns the age of the person associated with the ID number.

Remarks

• If id_number is not a valid South African 13-digit ID number, the function returns an error.
• If return_value is not specified, the function returns the age of the person associated with the ID number.
• Valid return values

  Errors

  For a full list of formula errors, please read Formula errors.

  
  

  Related functions

  • Calc CHAR function
  • Calc CLEAN function
  • Calc CODE function
  • Calc CONCAT function
  • Calc DETECTLANGUAGE function