Syntax of excel

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.


"Tapani Tuominen" wrote in message
...
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

"Tapani Tuominen" wrote...
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.

--
To top-post is human, to bottom-post and snip is sublime.