✦ Updated per latest Microsoft Docs

Complete Reference
Excel Functions

Search any function by name, Microsoft category or real-world use case — syntax, arguments, translated examples, errors and tips in one place.

Show 517 functions → Categories 📄 ۳۰ تابع پرکاربرد — PDF
▦
517 functions covered
⚡
۱۳ Excel categories
◆
۳۰ use cases
Quick Search 517 Functions
XLOOKUP SUMIFS VLOOKUP FILTER TEXTJOIN IF
Most popular today — by real score =SUM()
Mathematical sum
★ 100 · ◉ 6 =SUM(number1, [number2], ...)

Microsoft Categories

13 official Excel categories · real stats

Show 517 functions →
∑ Math & TrigMath & Trig 72 T TextText 46 ◐ LogicalLogical 19 ⌖ Lookup & ReferenceLookup & Reference 40 ◷ Date & TimeDate & Time 25 ▃ StatisticalStatistical 111 ₿ FinancialFinancial 56 ⓘ InformationInformation 22 ▦ DatabaseDatabase 12 ⚙ EngineeringEngineering 51 ⌁ WebWeb 3 ◧ CubeCube 7 ⇄ CompatibilityCompatibility 53

Popular Functions

By popularity score & most views

Most popular → Most viewed →
Math & Trig ★ 100 · ◉ 6 · All versions

=SUM()

Mathematical sum

=SUM(number1, [number2], ...)
Daily Tasks Reporting
Examples → Description
Lookup & Reference ★ 100 · ◉ 4 · Excel 2021

=XLOOKUP()

Searches a range and returns the corresponding value in the result range (row-wise or column-wise)

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
Daily Tasks Lookup & Retrieval
Examples → Description
Logical ★ 95 · ◉ 6 · All versions

=IF()

Decision structure, checking condition(s) and specifying alternative outcomes

=IF(logical_test, value_if_true, [value_if_false])
Daily Tasks Conditional Logic
Examples → Description
Lookup & Reference ★ 95 · ◉ 2 · All versions

=INDEX()

Returns the value at a specific position in a range

=INDEX(array, row_num, [column_num])
Daily Tasks Lookup & Retrieval
Examples → Description
Math & Trig ★ 90 · ◉ 404 · Excel 2007

=SUMIFS()

Sums with one or more conditions

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Daily Tasks Conditional Aggregation
Examples → Description
Lookup & Reference ★ 90 · ◉ 2 · Excel 2021

=FILTER()

Filters data by one or more conditions and returns only the matching results

=FILTER(array, include, [if_empty])
Daily Tasks Lookup & Retrieval
Examples → Description
Show 517 functions

Use Cases — 30 Real Scenarios

By your actual work — stats from 517 functions

All functions ←
Daily Tasks 43 Functions Lookup & Retrieval 15 Functions Conditional Aggregation 22 Functions Reporting 20 Functions Sort, Filter & Dedupe 7 Functions Ranking & Top N 21 Functions Data Cleaning 27 Functions Text Manipulation 36 Functions Comparation 20 Functions Conditional Logic 10 Functions Error Handling 21 Functions Conditional Formatting & Validation 24 Functions Date & Time Calculations 27 Functions Workdays & Due Dates 12 Functions Rounding & Numeric 23 Functions Numbering & Sample Data 11 Functions Descriptive Statistics 41 Functions Probability & Hypothesis Testing 49 Functions Forecasting & Trends 17 Functions Financial Calculations 57 Functions Loans & Installments 13 Functions Depreciation 7 Functions Investment Appraisal 11 Functions Securities & Bonds 28 Functions Reshape Tables 12 Functions Dynamic Ranges & Dashboards 17 Functions Advanced Formulas 10 Functions Worksheet Info & Navigation 16 Functions Scientific & Unit Conversion 27 Functions External Data, Web & Cube 12 Functions

Exceli

Type a name or description — even part of it. 517 functions ready.