Export (0) Print
Expand All
Expand Minimize

2.1.858 Part 1 Section 18.17.2.4, Functions

a. The standard does not use EBNF to write the productions for function-call.

Office writes the productions for function-call using the following EBNF:

function-call=
  function-name,  "(",  argument-list,  ")"    ;
function-name=
  predefined-function-name |
  user-defined-function-name ;
predefined-function-name=
  "ABS"  |  "ACOS"  |  "ACOSH"
  |  ( any of the other functions defined in Predefined Function Definitions ("[ISO/IEC-29500-1] §18.17.7"))  ;
user-defined-function-name=
  name-reference ;
argument-list=
  argument,  {  comma,  argument  }  ;
comma=
  ","  ;
argument=                   
  [expression]  ;

b. The standard states that a function is a named formula that takes zero or more arguments, performs an operation, and, optionally, returns a result.

In Office, a function always returns a result.

Show:
© 2014 Microsoft