Jump to content
Main menu
Main menu
move to sidebar
hide
Navigation
Main page
Recent changes
Random page
Help about MediaWiki
Special pages
Niidae Wiki
Search
Search
Appearance
Create account
Log in
Personal tools
Create account
Log in
Pages for logged out editors
learn more
Contributions
Talk
Editing
Microsoft Excel
(section)
Page
Discussion
English
Read
Edit
View history
Tools
Tools
move to sidebar
hide
Actions
Read
Edit
View history
General
What links here
Related changes
Page information
Appearance
move to sidebar
hide
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>
Summary:
Please note that all contributions to Niidae Wiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see
Encyclopedia:Copyrights
for details).
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)
Search
Search
Editing
Microsoft Excel
(section)
Add topic