Excel Function Reference by category
Functions alphabetically | Functions by category
Click on a link below to quickly navigate to category.
Function Categories | ||
---|---|---|
Compatibility | Financial | Math and trigonometry |
Database | Information | Statistical |
Date and Time | Logical | Text |
Engineering | Lookup and reference | Web |
Back to top
Database | ||
---|---|---|
DAVERAGE function | DMAX function | DSTDEVP function |
DCOUNT function | DMIN function | DSUM function |
DCOUNTA function | DPRODUCT function | DVARP function |
DGET function | DSTDEV function |
Back to top
Back to top
Back to top
Back to top
Back to top
Logical | ||
---|---|---|
AND function | IFNA function | SWITCH function |
FALSE function | IFS function | TRUE function |
IF function | NOT function | XOR function |
IFERROR function | OR function |
Back to top
Back to top
Back to top
Back to top
Back to top
Web | ||
---|---|---|
ENCODEURL function | WEBSERVICE function |
Back to top
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form