Home > Formulas > Math Trig > Topics Excel Math and Trigonometry Functions GuideA short guide to the Excel Math and Trigonometry functions, including SUM, SUMIFS, ROUND, RAND, and many more. Author: Debra Dalgleish 
Introduction: Excel Math and Trig FunctionsThese functions perform basic and advanced mathematical operations, such as addition, subtraction, multiplication, division, exponentiation, logarithms, and trigonometry. Some of the mostused mathematical functions are SUM (which adds up a range of numbers), AVERAGE (which calculates the average of a range of numbers), and ROUND (which rounds a number to a specified number of digits) This guide will give you a quick overview of key Math and Trig functions, and will lead you to indepth articles, where you'll find detailed examples, stepbystep videos, and sample files to download. 
Excel Sum FunctionsThe first Excel function that most people learn is SUM, to get the total for a range of cells that contain numbers. You can also calculate totals based on one criterion, using SUMIF, or multiple criteria, using SUMIFS. For a quick overview of 7 different ways to sum numbers with Excel functions, you can watch this 9minute video. There is a SUMIFS example, below the video, and a link to more examples. Video Timeline

Example  SUMIFS  Match multiple criteriaIn this example, the SUMIFS function will sum the amounts in column D, based on 2 criteria:
Those criteria are entered in cells F6 (Shipped) and G6 (10) To calculate the total amount, based on those two criteria, enter the following formula in cell A14:
Tip: To make the formula more flexible, so you can easily change the criteria if needed, refer to worksheet cells, instead of typing the criteria in the formula. For example:
More Information  Sum FunctionsClick the link to read more about the Excel Sum functions, including SUM, SUMIF and SUMIFS. You'll find examples, videos, and sample Excel files to download. 
RAND and RANDBETWEEN FunctionsThere are two Microsoft Excel functions that create random numbers  RAND and RANDBETWEEN. Here is a quick overview of what each function does:
Example  Create Random Text and NumbersIn this video, RANDBETWEEN creates a set of random test score data, for records in a sample data file. When combined with CHOOSE, the RANDBETWEEN function can even return random text. See the steps in this video, and the written instructions are below the video More Information  RAND and RANDBETWEENClick the link to read more about the Excel RAND and RANDBETWEEN functions. You'll find examples, videos, and sample Excel files to download. 
Rounding FunctionsAnother widelyused Excel math and trig function is ROUND, which rounds a number to a specified number of digits. There are other rounding functions too  ROUND, MROUND, FLOOR, CEILING and more. To see a quick overview of 7 ways to round in Excel, you can watch this short slide show. There are step by step instructions, and the sample file, on read more about the Excel Rounding functions page. Example  Round Age by DecadeIn this example, insteading of reducing the decimal places in a formula result, the ROUND function rounds by 10s. In the screen shot below, the age is rounded to the nearest decade, by using 1 as the number of decimal places to round. Because the number is negative, it rounds to the left of the decimal place.
More Information  Rounding FunctionsClick the link to read more about the Excel Rounding functions, including ROUND, MROUND, FLOOR, CEILING and more. You'll find examples, videos, and sample Excel files to download. 
More Math and Trig Function PagesGCD ExampleClick the link to read about calculating Ration in Excel, by using the GCD function. You'll find stepbystep instructions, videos, and sample Excel files to download. INT Function ExampleClick the link to read more about the Excel INT function, and see how it can extract the date, from a combined date and time.. You'll find examples, videos, and sample Excel files to download. SEQUENCE Function ExampleClick the link to read more about the Excel SEQUENCE function, and see how it can create a list of numbers. You'll find examples, and asample Excel file to download. 
All Excel Math and Trig FunctionsBelow is the full list of Excel Math and Trig Functions, and you can find more information on the Microsoft website.
To see the full list of Excel Math and Trig functions, click on the green check box below. When you're finished, you can click the check box again, to hide the full list Excel Math and Trig Functions  Full List

More Functions 
Last updated: September 13, 2023 12:27 PM