Skip to content

495 functions · TR / EN

Excel functions

All 495 Excel functions with their English and Turkish names. The most used ones each have a full page with syntax, arguments, examples checked in real Excel and common errors; the rest are listed by category with a short description.

Categories

Excel lookup and reference functions

37 functions · 21 full pages

Functions that find and return values from a table, report the position or size of a range, and filter, sort or reshape tables as dynamic arrays: VLOOKUP, XLOOKUP, INDEX, MATCH, FILTER, UNIQUE and more.

37 functions →

Excel logical functions

20 functions · 8 full pages

Functions that test conditions and decide based on the result: IF to pick one of two outcomes, AND / OR to combine tests, IFERROR to catch errors.

20 functions →

Excel math and sum functions

83 functions · 16 full pages

Functions for sums and conditional sums, rounding, remainders, powers and roots, random numbers and trigonometry. Everyday work leans on SUM, SUMIF, SUMIFS and ROUND.

83 functions →

Excel statistical and counting functions

145 functions · 17 full pages

Averages, counts, largest and smallest values, ranking, standard deviation and probability distributions. COUNTIF, COUNTIFS and AVERAGEIF are the most used for conditional counts and averages.

145 functions →

Excel text functions

46 functions · 20 full pages

Functions that cut, join, split, search, replace and format text: LEFT, MID, TRIM, SUBSTITUTE, TEXTJOIN, TEXTSPLIT, TEXT.

46 functions →

Excel date and time functions

25 functions · 15 full pages

Functions that build dates, split them into parts, count the days, months or workdays between two dates and find due dates: DATE, EDATE, DATEDIF, NETWORKDAYS, WORKDAY.

25 functions →

Excel financial functions

51 functions · 10 full pages

Loan payments, interest and principal parts, future and present value, net present value, internal rate of return, depreciation and bond calculations.

51 functions →

Excel information and web functions

22 functions · 3 full pages

Functions that test whether a cell is blank, a number, text or an error and report error types and cell details, plus the web functions that encode text for URLs.

22 functions →

Excel database functions

12 functions

The D… functions treat a list with headers as a database and sum, count or average the records that match a separate criteria range. In new workbooks SUMIFS and FILTER are usually preferred.

12 functions →

Excel engineering functions

54 functions

Unit conversion, binary / octal / hexadecimal conversions, bitwise operations, complex numbers, the error function and Bessel functions.

54 functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free