چیتشیت ۳۰ تابع پرکاربرد اکسل — اکسلی
۳۰ تابع پرکاربرد · A4نکته: با Ctrl+P (یا ⌘+P) این صفحه را به صورت PDF ذخیره کنید — طرح برای چاپ A4 بهینه است.
| # | Function | Description | Category | Syntax |
|---|---|---|---|---|
| 1 | =XLOOKUP | Use the XLOOKUP function when you need to find things in … | Lookup & Reference | =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) |
| 2 | =SUM | How to use the SUM function in Excel to add individual va… | Math & Trig | =SUM(number1,[number2],...) |
| 3 | =IF | How to use the IF function in Excel to make logical compa… | Logical | =IF(logical_test, value_if_true, [value_if_false]) |
| 4 | =INDEX | Returns the value of an element in a table or an array, s… | Lookup & Reference | =INDEX(array, row_num, [column_num]) |
| 5 | =MAX | Returns the largest value in a set of values. | Statistical | =MAX(number1, [number2], ...) |
| 6 | =FILTER | How to use the FILTER function in Excel to filter a range… | Lookup & Reference | =FILTER(array,include,[if_empty]) |
| 7 | =VLOOKUP | Learn how to use function VLOOKUP in Excel to find data i… | Lookup & Reference | =VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) |
| 8 | =MIN | Returns the smallest number in a set of values. | Statistical | =MIN(number1, [number2], ...) |
| 9 | =SUMIFS | How to use the SUMIFS function in Excel, one of Excel’s m… | Math & Trig | =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) |
| 10 | =AGGREGATE | The AGGREGATE function can apply different aggregate func… | Math & Trig | =AGGREGATE(function_num, options, ref1, [ref2], …) |
| 11 | =ROUND | The ROUND function rounds a number to a specified number … | Math & Trig | =ROUND(number, num_digits) |
| 12 | =UNIQUE | Learn about the UNIQUE function, which returns a list of … | Lookup & Reference | =UNIQUE(array,[by_col],[exactly_once]) |
| 13 | =SUMPRODUCT | How to use the SUMPRODUCT function in Excel, one of Excel… | Math & Trig | =SUMPRODUCT(array1, [array2], [array3], ...) |
| 14 | =SUBTOTAL | Returns a subtotal in a list or database. It is generally… | Math & Trig | =SUBTOTAL(function_num,ref1,[ref2],...) |
| 15 | =SMALL | Returns the k-th smallest value in a data set. Use this f… | Statistical | =SMALL(array, k) |
| 16 | =MATCH | How to use the MATCH function in Excel to search for a sp… | Lookup & Reference | =MATCH(lookup_value, lookup_array, [match_type]) |
| 17 | =TRIM | Removes all spaces from text except for single spaces bet… | Text | =TRIM(text) |
| 18 | =IFNA | The IFNA function returns the value you specify if a form… | Logical | =IFNA(value, value_if_na) |
| 19 | =COUNT | How to use the COUNT function in Excel to count the numbe… | Statistical | =COUNT(value1, [value2], ...) |
| 20 | =DATE | Use Excel's DATE function when you need to take three sep… | Date & Time | =: DATE(year,month,day) |
| 21 | =IFS | The IFS function checks whether one or more conditions ar… | Logical | =IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3) |
| 22 | =COUNTIFS | How to use the COUNTIFS function in Excel to apply criter… | Statistical | =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) |
| 23 | =XMATCH | The XMATCH function searches for a specified item in an a… | Lookup & Reference | =XMATCH(lookup_value, lookup_array, [match_mode], [search_mode]) |
| 24 | =LEFT | LEFT returns the first character or characters in a text … | Text | =LEFT(text, [num_chars]) |
| 25 | =COUNTA | The COUNTA function counts the number of cells that are n… | Statistical | =COUNTA(value1, [value2], ...) |
| 26 | =RIGHT | RIGHT returns the last character or characters in a text … | Text | =RIGHT(text,[num_chars]) |
| 27 | =DATEDIF | Calculates the number of days, months, or years between t… | Date & Time | =DATEDIF(start_date,end_date,unit) |
| 28 | =AVERAGE | Returns the average (arithmetic mean) of the arguments. F… | Statistical | =AVERAGE(number1, [number2], ...) |
| 29 | =MID | MID returns a specific number of characters from a text s… | Text | =MID(text, start_num, num_chars) |
| 30 | =ISBLANK | Checks whether a cell is empty or not? | Information | =ISBLANK(value) |