# Functions

## MMULT Excel Function for Matrix Multiplication

Since a worksheet is essentially a gigantic matrix, it’s no surprise that matrix multiplication in Excel is super easy – we just need to use […]

## Using the CONVERT Function for Compound Unit Conversions

Excel’s convert function works well to convert between simple units. However, in engineering, there’s often compounds units where simple units are either multiplied together or

## Rounding Functions in Excel

Excel has several functions for rounding numbers. Function Description INT Rounds down to the nearest integer ROUND Rounds the number to a specified number of

## Trigonometric Functions in Excel

Excel contains a variety of trigonometric functions: Basic functions Hyperbolic functions Inverse functions Miscellaneous SIN SINH ASIN PI() COS COSH ACOS RADIANS TAN TANH ATAN

## SUMPRODUCT and SUMSQ Excel Functions

There are two more advanced summing functions that we’ll discuss – SUMPRODUCT and SUMSQ. SUMPRODUCT multiplies individual components in arrays together and then returns the

## SUMIF and SUMIFS Excel Functions for Engineering Calculations

This section and the next will cover the advanced summing functions available in Excel. The SUMIF and SUMIFS functions enable you to sum values in

## LN, LOG, LOG10, EXP, SQRT, and FACT Functions in Excel

Excel features many of the common mathematical functions that you’ll encounter in engineering: logarithms, exponentials, square roots and factorials. This section covers three example problems

## Complex Number Functions in Excel

If you do any engineering calculations that involve complex numbers, you’ll probably appreciate the complex number functions that are built into Excel. Excel has many

Scroll to Top
Complete... 50%