Below is the list of 43 Excel math functions:
| Function | Formula |
|---|---|
| ABS Function | Abs(Num) |
| BASE Function | Base(Num, Radix [Min_Length]) |
| CEILING Function | Ceiling(Num, Significance) |
| CEILING.PRECISE Function | Ceiling.Precise(Num, Significance) |
| COMBIN Function | Combin(Num, Num_Chosen) |
| COMBINA Function | Combina(Num, Num_Chosen) |
| DECIMAL Function | Decimal(Text, Radix) |
| DEGREES Function | Degrees(Angle) |
| EVEN Function | Even(Num) |
| EXP Function | Exp(Num) |
| FACT Function | Fact(Num) |
| FACTDOUBLE Function | Factdouble(Num) |
| FLOOR Function | Floor(Num, Significance) |
| FLOOR.PRECISE Function | Floor.Precise(Num, [Significance]) |
| INT Function | Int(Num) |
| LN Function | Ln(Num) |
| LOG Function | Log(Num, [Base]) |
| LOG10 Function | Log10(Num) |
| MOD Function | Mod(Num, Divisor) |
| MROUND Function | Mround(Num, Multiple) |
| ODD Function | Odd(Num) |
| PI Function | Pi() |
| POWER Function | Power(Num, Power) |
| PRODUCT Function | Product(Num1, [Num2], …) |
| QUOTIENT Function | Quotient(Numerator, Denominator) |
| RADIANS Function | Radians(Angle) |
| RAND Function | Rand() |
| RANDBETWEEN Function | Randbetween(Bottom, Top) |
| ROMAN Function | Roman(Num, [Form]) |
| ROUND Function | Round(Num, Num_Digits) |
| ROUNDDOWN Function | Rounddown(Num, Num_Digits) |
| ROUNDUP Function | Roundup(Num, Num_Digits) |
| SQRT Function | Sqrt(Num) |
| SQRTPI Function | Sqrtpi(Num) |
| SUM Function | Sum(Num1,[Num2],…) |
| SUMIF Function | Sumif(Range, Criteria, [Sum_Range]) |
| SUMIFS Function | Sumifs(Sum_Range, Range1, Criteria1, [Range2, Criteria2], …) |
| SUMPRODUCT Function | Sumproduct(Array1, [Array2], [Array3], …) |
| SUMSQ Function | Sumsq(Num1, [Num2], …) |
| SUMX2MY2 Function | Sumx2My2(Array_X, Array_Y) |
| SUMX2PY2 Function | Sumx2Py2(Array_X, Array_Y) |
| SUMXMY2 Function | Sumxmy2(Array_X, Array_Y) |
| TRUNC Function | Trunc(Num, [Num_Digits]) |