Syntax of excel

[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

 

[Dave R.]

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.

 

[Harlan Grove]

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?

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.