There are 58 math and trigonometry functions varying in yada usefulness, power and potential complexity.

Function | Usefulness | Power | Complexity |
---|---|---|---|

ABS | |||

ACOS | |||

ACOSH | |||

ASIN | |||

ASINH | |||

ATAN | |||

ATAN2 | |||

ATANH | |||

CEILING | |||

CEILING.PRECISE | |||

COMBIN | |||

COS | |||

COSH | |||

DEGREES | |||

EVEN | |||

EXP | |||

FACT | |||

FACTDOUBLE | |||

FLOOR | |||

FLOOR.PRECISE | |||

GCD | |||

INT | |||

ISO.CEILING | |||

LCM | |||

LN | |||

LOG | |||

LOG10 | |||

MOD | |||

MROUND | |||

MULTINOMIAL | |||

ODD | |||

PI | |||

POWER | |||

PRODUCT | |||

QUOTIENT | |||

RADIANS | |||

RAND | |||

RANDBETWEEN | |||

ROMAN | |||

ROUND | |||

ROUNDDOWN | |||

ROUNDUP | |||

SIGN | |||

SIN | |||

SINH | |||

SQRT | |||

SQRTPI | |||

SUM | |||

SUMIF | |||

SUMIFS | |||

SUMPRODUCT | |||

SUMSQ | |||

SUMX2MY2 | |||

SUMX2PY2 | |||

SUMXMY2 | |||

TAN | |||

TANH | |||

TRUNC |

#### Basic Math Functions

#### Rounding Functions

Function | Usefulness | Power | Complexity |
---|---|---|---|

CEILING | |||

CEILING.PRECISE | |||

EVEN | |||

FLOOR | |||

FLOOR.PRECISE | |||

INT | |||

ISO.CEILING | |||

MROUND | |||

ODD | |||

ROUND | |||

ROUNDDOWN | |||

ROUNDUP | |||

TRUNC |

#### Random Number Functions

Function | Usefulness | Power | Complexity |
---|---|---|---|

RAND | |||

RANDBETWEEN |

#### Series and Matrix Functions

Function | Usefulness | Power | Complexity |
---|---|---|---|

SUMPRODUCT | |||

SUMSQ | |||

SUMX2MY2 | |||

SUMX2PY2 | |||

SUMXMY2 |

#### Trigonometry Functions

#### Exponentials and Logarithms Functions

Function | Usefulness | Power | Complexity |
---|---|---|---|

EXP | |||

FACT | |||

FACTDOUBLE | |||

LN | |||

LOG | |||

LOG10 | |||

MULTINOMIAL |

##### Using a Math and Trigonometry function:

### Summary

Excel's math and trigonometry functions perform both basic and complex mathematical and trigonometric calculations.