| ABS | Returns the absolute value of a number | =ABS(Number) |
| AND | Returns TRUE if all arguments are TRUE | =AND(Logicalvalue1; Logicalvalue2; …Logicalvalue30) |
| AVERAGE | Returns the numerical average of its arguments, ignoring text | =AVERAGE(Number1; Number2; …Number30) |
| CEILING | Rounds a number up to the nearest integer multiple of specified significance. | =CEILING(Number; [Significance]) |
| CHOOSE | Choose a value to perform from a list based on an index number | =CHOOSE(Index; Value1; …; Value30) |
| CONCAT | Joins several text strings into one string | =CONCAT(Text1; …; Text30) |
| CONCATENATE | Joins several text strings into one string | =CONCATENATE(Text1; …; Text30) |
| COUNT | Counts the number of cells in a range | =COUNT(Value1; Value2; … Value30) |
| COUNTA | Counts the number of cells in a range that are not empty | =COUNTA(Value1; Value2; … Value30) |
| COUNTIF | Counts the number of cells within a range that meet the given condition | =COUNTIF(Range; Criteria) |
| COUNTIFS | Counts the number of cells specified by a given set of conditions | =COUNTIFS(Range1; Criterion1[; Range2; Criterion2[; …]]) |
| DATEDIF | Calculates distance between two dates, in provided unit parameter | =DATEDIF(Date1; Date2; Units) |
| DAY | Returns the day of the given date value | =DAY(Number) |
| DAYS | Calculates the difference between two date values | =DAYS(Date2; Date1) |
| EDATE | Shifts the given startdate by given number of months | =EDATE(Startdate; Months) |
| EOMONTH | Returns the date of the last day of a month which falls months away from the start date | =EOMONTH(Startdate; Months) |
| FLOOR | Rounds a number down to the nearest integer multiple of specified significance. | =FLOOR(Number; [Significance]) |
| HOUR | Returns hour component of given time | =HOUR(Time) |
| IF | Specifies a logical test to be performed | =IF(Test; Then value; Otherwisevalue) |
| IRR | Returns the internal rate of return for a series of cash flows | =IRR(Values; [Guess]) |
| ISBLANK | Returns TRUE if the reference to a cell is blank | =ISBLANK(Value) |
| ISERR | Returns TRUE if the value is error value except #N/A! | =ISERR(Value) |
| ISERROR | Returns TRUE if the value is general error value | =ISERROR(Value) |
| ISEVEN | Returns TRUE if the value is an even integer, or FALSE if the value is odd | =ISEVEN(Value) |
| ISNA | Returns TRUE if the value is #N/A! error | =ISNA(Value) |
| ISNUMBER | Returns TRUE if the value refers to a number | =ISNUMBER(Value) |
| ISODD | Returns TRUE if the value is odd, or FALSE if the number is even | =ISODD(Value) |
| ISTEXT | Returns TRUE if the cell contents refer to text | =ISTEXT(Value) |
| LARGE | Returns k-th largest value in a range | =LARGE(Range; K) |
| LEFT | Extracts a given number of characters from the left side of a text string | =LEFT(Text; Number) |
| LOWER | Returns text converted to lowercase | =LOWER(Text) |
| MAX | Returns the maximum value in a list of arguments | =MAX(Number1; Number2; …Number30) |
| MEDIAN | Returns the median of a set of numbers | =MEDIAN(Number1; Number2; …Number30) |
| MID | Returns substring of a given length starting from Start_position | =MID(Text, Start_position, Length) |
| MIN | Returns the minimum value in a list of arguments | =MIN(Number1; Number2; …Number30) |
| MINUTE | Returns minute component of given time | =MINUTE(Time) |
| MONTH | Returns the month for the given date value | =MONTH(Number) |
| NOT | Complements (inverts) a logical value | =NOT(Logicalvalue) |
| NOW | Returns current date + time | =NOW() |
| NPV | Returns the net present value of an investment based on a discount rate and a series of cashflows | =NPV(Rate; Value1; Value2; …Value30) |
| OR | Returns TRUE if at least one argument is TRUE | =OR(Logicalvalue1; Logicalvalue2 …Logicalvalue30) |
| PROPER | Capitalizes words given text string | =PROPER(Text) |
| RAND | Returns a random number between 0 and 1 | =RAND() |
| RANDBETWEEN | Returns a random integer between two numbers | =RAND(Lowerbound; Upperbound) |
| RIGHT | Extracts a given number of characters from the right side of a text string | =RIGHT(Text; Number) |
| ROUND | Rounds a number to a certain number of decimal places | =ROUND(Number; Count) |
| ROUNDDOWN | Rounds a number down, toward zero, to a certain precision | =ROUNDDOWN(Number; Count) |
| ROUNDUP | Rounds a number up, away from zero, to a certain precision | =ROUNDUP(Number; Count) |
| SECOND | Returns second component of given time | =SECOND(Time) |
| SMALL | Returns k-th smallest value in a range | =SMALL(Range; K) |
| SUM | Adds all the numbers in a range of cells | =SUM(Number1; Number2; …; Number30) |
| SUMIF | Adds the cells specified by a given condition or criteria | =SUMIF(Range; Criteria; Sumrange) |
| SUMIFS | Adds the cells specified by a given set of conditions or criteria | =SUMIFS(Sum_Range; Criterion_range1; Criterion1[; Criterion_range2; Criterion2[;…]]) |
| SUMPRODUCT | Multiplies corresponding elements in the given arrays, and returns the sum of those products | =SUMPRODUCT(Array1; Array2…Array30) |
| TODAY | Returns current date | =TODAY() |
| UPPER | Returns text converted to uppercase | =UPPER(Text) |
| WEEKDAY | Computes a number between 1-7 representing the day of week | =WEEKDAY(Date; Type) |
| WEEKNUM | Returns a week number that corresponds to the week of year | =WEEKNUM(Date; Type) |
| YEAR | Returns the year as a number according to the internal calculation rules | =YEAR(Number) |
