搜尋結果
A complete list of all Excel functions in alphabetical order.
This page provides a complete Excel Functions list, grouped by category. Each of the function links will take you to a dedicated page, where you will find a description of the function, with examples of use and details of common errors.
Excel Functions List with free downloadable examples. Learn the syntax for 200+ of the most commonly used Excel and Google Sheets functions.
Over 350 built-in functions, with examples and videos. VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, ROUND, SUMPRODUCT, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, SEQUENCE, FIND, SEARCH, DATE, and more. Also see 500 Formulas and 101 Functions.
Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.
在較新版本的 Excel 中,這些函數已由新函數取代,新函數可提供更佳的準確性,並擁有更能反映其使用方式的名稱。 您還是可以使用這些函數以與舊版 Excel 相容,但是,若不需要回溯相容性,您應該開始使用新函數。
Excel 里的函数是预先写好的一个运算公式,接受零或多个参数返回计算结果。 Excel 已内置文本函数、逻辑函数、财务函数和数学与三角函数等不同分类的函数供用户直接使用。
Below is a brief overview of about 100 important Excel functions you should know, with links to detailed examples. We also have a large list of example formulas , a more complete list of Excel functions, and video training. If you are new to Excel formulas, see this introduction.
2023年3月21日 · Excel functions list with formula examples that explain the use of text functions, math, logical and statistical functions, date and time functions, and more.
Sumit Bansal. FREE EXCEL TIPS EBOOK - Click here to get your copy. Here, you will find a detailed tutorial on 100+ Excel Functions & VBA Functions. Each Excel function is covered in detail with Examples and Videos. This Tutorial Covers: Excel Functions – Date and Time. Excel Functions – Logical. Excel Functions – Lookup & Reference.