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

2.1.857 Part 1 Section, 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-name,  "(",  argument-list,  ")"    ;
   predefined-function-name |
   user-defined-function-name ;
   "ABS"  |  "ACOS"  |  "ACOSH"
   |  ( any of the other functions defined in Predefined Function Definitions ("[ISO/IEC-29500-1] §18.17.7"))  ;
   name-reference ;
   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.

© 2016 Microsoft