If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Syntax of excel
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 |
#3
|
|||
|
|||
Syntax of excel
"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. |
Thread Tools | |
Display Modes | |
|
|