Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

2.1.857 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:
© 2016 Microsoft