Click a letter to go to functions that start with it. 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.
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
NOTE: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions.
IMPORTANT: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.
Web : excel
| Function | Purpose | Param,Optional |
|---|---|---|
| DATE | Create a valid date from year, month, and day | yearmonthday |
| DATEDIF | Get days, months, or years between two dates | start_dateend_dateunit |
| DATEVALUE | Convert a date in text format to a valid date | date_text |
| DAY | Get the day as a number (1-31) from a date | date |
| DAYS | Get days between dates | end_datestart_date |
| DAYS360 | Get days between 2 dates in a 360-day year | start_dateend_datemethod |
| EDATE | Get the same date in future or past months | start_datemonths |
| EOMONTH | Get the last day of the month in future or past months | start_datemonths |
| HOUR | Get the hour as a number (0-23) from a Time | serial_number |
| ISOWEEKNUM | Get ISO week number for a given date | date |
| MINUTE | Get the minute as a number (0-59) from a time | serial_number |
| MONTH | Get the month as a number (1-12) from a date | date |
| NETWORKDAYS | Get the number of working days between two dates | start_dateend_dateholidays |
| NETWORKDAYS.INTL | Get work days between two dates | start_dateend_dateweekendholidays |
| NOW | Get the current date and time | |
| SECOND | Get the Second as a number (0-59) from a Time | serial_number |
| TIME | Create a time with hours, minutes, and seconds | hourminutesecond |
| TIMEVALUE | Get a valid time from a text string | time_text |
| TODAY | Get the current date | |
| WEEKDAY | Get the day of the week as a number | serial_numberreturn_type |
| WEEKNUM | Get the week number for a given date | serial_numreturn_type |
| WORKDAY | Get a date n working days in the future or past | start_datedaysholidays |
| WORKDAY.INTL | Get date and working days in future or past | start_datedaysweekendholidays |
| YEAR | Get the year from a date | date |
| YEARFRAC | Get the fraction of a year between two dates | start_dateend_datebasis |
Engineering
| Function | Purpose | Param,Optional |
|---|---|---|
| CONVERT | Convert measurement units | numberfrom_unitto_unit |
Financial
| Function | Purpose | Param,Optional |
|---|---|---|
| FV | Get the future value of an investment | ratenperpmtpvtype |
| NPER | Get the number of periods for an investment | ratepmtpvfvtype |
| PMT | Get the periodic payment for a loan | ratepmtpvfvtype |
| PV | Get the present value of an investment | ratenperpmtfvtype |
| RATE | Get the interest rate per period of an annuity | nperpmtpvfvtypeguess |
Information
Filter:
| Function | Purpose | Param,Optional |
|---|---|---|
| CELL | Get information about a cell | info_typereference |
| ERROR.TYPE | Test for a specific error value | error_val |
| INFO | Get information about current environment | type_text |
| ISBLANK | Test if a cell is empty | value |
| ISERR | Test for any error but #N/A | value |
| ISERROR | Test for any error | value |
| ISEVEN | Test if a value is even | value |
| ISFORMULA | Test if cell contains a formula | reference |
| ISLOGICAL | Test if a value is logical | value |
| ISNA | Test for the #N/A error | value |
| ISNUMBER | Test for numeric value | value |
| ISODD | Test if a value is odd | value |
| ISREF | Test for a reference | value |
| ISTEXT | Test for a text value | value |
| N | Convert a value to a number | value |
| NA | Create an #N/A error | |
| TYPE | Get the type of value in a cell | value |
Logical
Filter:
| Function | Purpose | Param,Optional |
|---|---|---|
| AND | Test multiple conditions with AND | logical1logical2... |
| FALSE | Generate the logical value FALSE | |
| IF | Test for a specific condition | logical_testvalue_if_truevalue_if_false |
| IFERROR | Trap and handle errors | valuevalue_if_error |
| NOT | Reverse arguments or results | logical |
| OR | Test multiple conditions with OR | logical1logical2... |
| TRUE | Generate the logical value TRUE | |
| LOG | Get the logarithm of a number | numberbase |
Lookup and reference
Filter:
| Function | Purpose | Param,Optional |
|---|---|---|
| ADDRESS | Create a cell address from a given row and column | row_numcol_numabs_numa1sheet |
| AREAS | Get the number of areas in a reference. | reference |
| CHOOSE | Get a value from a list based on position | index_numvalue1value2... |
| COLUMN | Get the column number of a reference. | reference |
| COLUMNS | Get the number of columns in an array or reference. | array |
| FORMULATEXT | Get the formula in a cell | reference |
| HLOOKUP | Look up a value in a table by matching on the first row | valuetablerow_indexrange_lookup |
| HYPERLINK | Create a clickable link. | link_locationfriendly_name |
| INDEX | Get a value in a list or table based on location | arrayrow_numcol_numarea_num |
| INDIRECT | Create a reference from text | ref_texta1 |
| LOOKUP | Look up a value in a one-column range | lookup_valuelookup_vectorresult_vector |
| MATCH | Get the position of an item in an array | lookup_valuelookup_arraymatch_type |
| OFFSET | Create a reference offset from given starting point | referencerowscolsheightwidth |
| ROW | Get the row number of a reference | reference |
| ROWS | How to use the Excel ROWS function to Get the number of rows in an array or reference. | array |
| TRANSPOSE | Flip the orientation of a range of cells | array |
| VLOOKUP | Lookup a value in a table by matching on the first column | valuetablecol_indexrange_lookup |
Math
Filter:
| Function | Purpose | Param,Optional |
|---|---|---|
| ABS | Find the absolute value of a number | number |
| CEILING | Round a number up to the nearest specified multiple | numbermultiple |
| COS | Get the cosine of an angle | number |
| DEGREES | Converts an angle into degrees | angle |
| EVEN | Round a number up to the next even integer | number |
| EXP | Find the value of e raised to the power of a number | number |
| FACT | Find the factorial of a number | number |
| FLOOR | Round a number down to the nearest specified multiple | numbermultiple |
| GCD | Get the greatest common divisor of two or more numbers | number1number2... |
| INT | Get the integer part of a decimal by rounding down | number |
| LCM | Get the least common multiple or two or more numbers | number1number2... |
| LOG10 | Get the base-10 logarithm of a number | number |
| MOD | Get the remainder from division | numberdivisor |
| MROUND | Round a number to the nearest specified multiple | numbermultiple |
| ODD | Round a number up to the next odd integer | number |
| PI | Get the value of π | |
| RADIANS | Converts an angle into radians | angle |
| RAND | Get a random number between 0 and 1 | |
| RANDBETWEEN | Get a random integer between two values | bottomtop |
| ROUND | Round a number to a given number of digits | numbernum_digits |
| ROUNDDOWN | Round a number down to a given number of digits | numbernum_digits |
| ROUNDUP | Round a number up to a given number of digits | numbernumber_digits |
| SIGN | Get the sign of a number. | number |
| SIN | Get the sine of an angle | number |
| SQRT | Find the positive square root of a number | number |
| SUBTOTAL | Get a subtotal in a list or database | function_numref1ref2... |
| SUM | Add numbers together | number1number2number3... |
| SUMIF | Sum numbers in a range that meet supplied criteria | rangecriteriasum_range |
| SUMPRODUCT | Multiply, then sum arrays | array1array2... |
| TAN | Get the tangent of an angle. | number |
Statistical
Filter:
| Function | Purpose | Param,Optional |
|---|---|---|
| AVERAGE | Get the average of a group of numbers | number1number2... |
| AVERAGEA | Get the average of a group of numbers and text | value1value2... |
| AVERAGEIF | Get the average of numbers that meet criteria | rangecriteriaaverage_range |
| COUNT | Count numbers | value1value2... |
| COUNTA | Count the number of non-blank cells | value1value2... |
| COUNTBLANK | excel-countblank-function | range |
| COUNTIF | Count cells that match criteria | rangecriteria |
| COUNTIFS | Count cells that match multiple criteria | range1criteria1range2criteria2... |
| FREQUENCY | Get the frequency of values in a data set | data_arraybins_array |
| LARGE | Get the nth largest value | arrayn |
| MEDIAN | Get the median of a group of numbers | number1numer2... |
| MIN | Get the smallest value. | array |
| MODE | Get the mode of a group of numbers | number1number2... |
| RANK | Rank a number against a range of numbers | numberarrayorder |
| SMALL | Get the nth smallest value | arrayn |
| STDEV | Get the standard deviation in a sample | number1number2... |
| STDEV.P | Get standard deviation of population | number1number2... |
| STDEV.S | Get the standard deviation in a sample | number1number2... |
| STDEVP | Get standard deviation of population | number1number2... |
Text
Filter:
| Function | Purpose | Param,Optional |
|---|---|---|
| CHAR | Get a character from a number | number |
| CLEAN | Strip non-printable characters from text | text |
| CODE | Get the code for a character | text |
| CONCATENATE | Join text together | text1text2text3... |
| DOLLAR | Convert a number to text in currency format | numberdecimals |
| EXACT | Compare two text strings | text1text2 |
| FIND | Get the location of text in a string | |
| LEFT | Extract text from the left of a string | |
| LEN | Get the length of text. | |
| LOWER | Convert text to lower case | |
| MID | Extract text from inside a string | |
| PROPER | Capitalize the first letter in each word | |
| REPLACE | Replace text based on location | |
| REPT | Repeat text as specified | |
| RIGHT | Extract text from the right of a string | |
| SEARCH | Get the location of text in a string | |
| SUBSTITUTE | Replace text based on content | |
| TEXT | Convert a number to text in a number format | |
| TRIM | Remove extra spaces from text | |
| UPPER | Convert text to upper case | textnum_chars |
| VALUE | Convert text to a number | text |
Không có nhận xét nào:
Đăng nhận xét