| Function | Purpose | Param,Optional |
|---|---|---|
| SECOND | Get the Second as a number (0-59) from a Time | serial_number |
| TIME | Create a time with hours, minutes, and seconds | hour minute second |
| 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_date daysholidays |
| WORKDAY.INTL | Get date and working days in future or past | start_date daysweekend holidays |
| YEAR | Get the year from a date | date |
| YEARFRAC | Get the fraction of a year between two dates | start_date end_datebasis |
| Function | Purpose | Param,Optional |
|---|---|---|
| CONVERT | Convert measurement units | number from_unit to_unit |
| Function | Purpose | Param,Optional |
|---|---|---|
| FV | Get the future value of an investment | rate nper pmtpv type |
| NPER | Get the number of periods for an investment | rate pmt pvfv type |
| PMT | Get the periodic payment for a loan | rate pmt pvfv type |
| PV | Get the present value of an investment | rate nper pmtfv type |
| RATE | Get the interest rate per period of an annuity | nper pmt pvfv type guess |
| Function | Purpose | Param,Optional |
|---|---|---|
| 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 |
| Function | Purpose | Param,Optional |
|---|---|---|
| AND | Test multiple conditions with AND | logical1logical2 ... |
| FALSE | Generate the logical value FALSE | |
| IFERROR | Trap and handle errors | value value_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 |
| Function | Purpose | Param,Optional |
|---|---|---|
| HYPERLINK | Create a clickable link. | link_locationfriendly_name |
| LOOKUP | Look up a value in a one-column range | lookup_value lookup_vectorresult_vector |
| MATCH | Get the position of an item in an array | lookup_value lookup_arraymatch_type |
| 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 | value table col_indexrange_lookup |
| Function | Purpose | Param,Optional |
|---|---|---|
| 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_num ref1ref2 ... |
| SUM | Add numbers together | number1number2 number3 ... |
| SUMIF | Sum numbers in a range that meet supplied criteria | range criteriasum_range |
| SUMPRODUCT | Multiply, then sum arrays | array1array2 ... |
| TAN | Get the tangent of an angle. | number |
| Function | Purpose | Param,Optional |
|---|---|---|
| LARGE | Get the nth largest value | array n |
| 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 | number arrayorder |
| SMALL | Get the nth smallest value | array n |
| 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 ... |
| Function | Purpose | Param,Optional |
|---|---|---|
| TRIM | Remove extra spaces from text | |
| UPPER | Convert text to upper case | textnum_chars |
| VALUE | Convert text to a number | text |