Open main menu
Home
Random
Recent changes
Special pages
Community portal
Preferences
About Wikipedia
Disclaimers
Incubator escapee wiki
Search
User menu
Talk
Dark mode
Contributions
Create account
Log in
Editing
Microsoft Excel
(section)
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
=== Functions === {{See also|Microsoft Power Fx}} Excel 2016 has 484 functions.<ref>{{cite web|title=Excel functions (alphabetical)|url=https://support.office.com/en-us/article/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188|url-status=live|access-date=November 4, 2018|website=microsoft.com|publisher=Microsoft|archive-date=November 5, 2018|archive-url=https://web.archive.org/web/20181105062357/https://support.office.com/en-us/article/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188}}</ref> Of these, 360 existed prior to Excel 2010. Microsoft classifies these functions into 14 categories. Of the 484 current functions, 386 may be called from [[Visual Basic for Applications|VBA]] as methods of the object "WorksheetFunction"<ref>{{cite web|date=March 30, 2022|title=WorksheetFunction Object (Excel)|url=https://docs.microsoft.com/en-us/office/vba/api/excel.worksheetfunction|url-status=live|access-date=November 4, 2018|website=Office VBA Reference|publisher=Microsoft|archive-date=November 5, 2018|archive-url=https://web.archive.org/web/20181105062450/https://docs.microsoft.com/en-us/office/vba/api/excel.worksheetfunction}}</ref> and 44 have the same names as VBA functions.<ref>{{cite web|date=September 13, 2021|title=Functions (Visual Basic for Applications)|url=https://docs.microsoft.com/en-us/office/vba/language/reference/functions-visual-basic-for-applications|url-status=live|access-date=November 4, 2018|website=Office VBA Reference|publisher=Microsoft|archive-date=November 5, 2018|archive-url=https://web.archive.org/web/20181105062438/https://docs.microsoft.com/en-us/office/vba/language/reference/functions-visual-basic-for-applications}}</ref> With the introduction of LAMBDA, Excel became [[Turing complete]].<ref>{{cite web|last=Gordon|first=Andy|date=January 25, 2021|title=LAMBDA: The ultimate Excel worksheet function|url=https://www.microsoft.com/en-us/research/blog/lambda-the-ultimatae-excel-worksheet-function/|url-status=live|access-date=April 23, 2021|website=microsoft.com|publisher=Microsoft|archive-date=April 23, 2021|archive-url=https://web.archive.org/web/20210423120636/https://www.microsoft.com/en-us/research/blog/lambda-the-ultimatae-excel-worksheet-function/}}</ref>
Edit summary
(Briefly describe your changes)
By publishing changes, you agree to the
Terms of Use
, and you irrevocably agree to release your contribution under the
CC BY-SA 4.0 License
and the
GFDL
. You agree that a hyperlink or URL is sufficient attribution under the Creative Commons license.
Cancel
Editing help
(opens in new window)