Syntax of excel

  • Thread starter Thread starter Tapani Tuominen
  • Start date Start date
T

Tapani Tuominen

I have unsuccesfully tried to find out if there exists a syntax for excel
functions. Excel help uses word syntax, but fails to give the syntax for
arguments of functions: gives semantics instead of syntax for arguments.
Anyone know if a proper syntax exists?

Tapani Tuominen
 
Syntax for Excel functions is available in help in any version I've used..

Doesn't

Syntax
SUMPRODUCT(array1,array2,array3, ...)

come close enough for you? They are followed by examples in Help also.
 
I have unsuccesfully tried to find out if there exists a syntax for excel
functions. Excel help uses word syntax, but fails to give the syntax for
arguments of functions: gives semantics instead of syntax for arguments.
Anyone know if a proper syntax exists?
Click to expand...

If you mean a formal grammar, no. You could try looking through the source code
for either OpenOffice Calc or Gnumeric, both of which would come close to Excel,
but such a grammar for Excel would be part of Microsoft's jealously and
furiously defended proprietary IP. The only way you could *legally* see it would
be to work for Microsoft as an Excel developer.
 
Back
Top