Category:Excel: Difference between revisions

← Older edit

Category:Excel (view source)

Revision as of 14:29, 31 May 2021

798 bytes added , 2 years ago

Updated categorisation of Excel formula language, which is now (in recent builds) Turing complete.

Hout

9,655

edits

Revision as of 15:08, 11 July 2015 (view source) Simple9371 (talk \| contribs) (Excel I think this is enough for now...) ← Older edit		Latest revision as of 14:29, 31 May 2021 (view source) Hout (talk \| contribs) (Updated categorisation of Excel formula language, which is now (in recent builds) Turing complete.)
(4 intermediate revisions by the same user not shown)
Line 1: {{~~stub}}{{np~~ language\|Excel}} {{language programming paradigm\|Declarative}} [[wp:Microsoft_Excel\|Excel]] is a [[wp:Spreadsheet\|spreadsheet]] program from [[wp:Microsoft_Office\|Microsoft Office]] suite applications. Excel provides calculations, [[wp:Spreadsheet#Cell_reference\|cell referencing]], and illustration of data sheets by using its ''functions'', ''formulas'', ''graphs'', etc. Hence, even though Excel is not a programming application/language, it can be used to solve certain programming related tasks.▼ {{language programming paradigm\|functional}} ▲[[wp:Microsoft_Excel\|Excel]] is a [[wp:Spreadsheet\|spreadsheet]] program from [[wp:Microsoft_Office\|Microsoft Office]] suite applications. Excel provides calculations, [[wp:Spreadsheet#Cell_reference\|cell referencing]], and illustration of data sheets by using its ''functions'', ''formulas'', ''graphs'', etc. ~~Hence, even though Excel is not a programming application/language, it can be used to solve certain programming related tasks.~~ The Excel formula language consists of several hundred pure functions, and only constitutes a Turing-complete programming language in recent builds (Office 365 beta, [https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-turn-excel-formulas-into-custom-functions/ba-p/1925546 since Dec 2020]) which have introduced a LAMBDA function, and the ability to bind names to reusable custom functions in the Excel Name Manager. The Excel formula language, for all its limitations, is arguably the most widely used programming language in the world. Estimates of the number of users are typically in the region of 750 million. (See [https://www.microsoft.com/en-us/research/blog/lambda-the-ultimatae-excel-worksheet-function/ The LAMBDA worksheet function]) (and, of course: [https://xkcd.com/2453/ XKCD 2453 - Excel Lambda])