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.
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.
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.
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.
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.
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.
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.
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.
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.
Excel engineering functions
54 functions
Unit conversion, binary / octal / hexadecimal conversions, bitwise operations, complex numbers, the error function and Bessel 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