# 40+ Excel Mathematical Formulas List PDF

‘Mathematical Functions In Excel’ PDF Quick download link is given at the bottom of this article. You can see the PDF demo, size of the PDF, page numbers, and direct download Free PDF of ‘MS Excel Maths Formula’ using the download button.

## Basic Maths Operations With Example In MS Excel PDF Free Download

### Microsoft Excel Step By Step Maths Functions

#### Simple arithmetic

Problem 1: Add two numbers

Steps:

1. Open a spreadsheet and type in the labels called number 1 and number 2 in cells A1 and B1 and add in cell C1. This is just for us to identify the values and they are not involved in the actual execution
2. In A2 and B2, type in the numbers to be added.
3. In C2, type in =A2+B2 and press enter to display the result. In excel calculations are prefixed with = sign followed by the operation on cells
4. The cell number represents the numbers (For e.g A2 and B2 are used which denote 3 and 5 respectively with a plus sign in between as in the case of normal addition.
5. To add more than two numbers, add as many columns (number1, number2, number3 etc., and extend the formula as =A2+B2+C2+….

#### Simple statistical functions

Problem 2: Let us consider the problem of finding the total and average of 3 subject marks for five students in a class in the board exam. The data is entered into the spreadsheet as shown below:

Steps:

1. To calculate sum, type =sum( in the cell F2 and click and drag the cells C2, D2 and E2 i.e., =sum(C2:E2) where : denotes the range to add maths physics and chemistry marks of student no1.
2. For calculating sum for other students, click and drag the sum value of F2 till F6
3. Similarly calculate average as =average(C2,D2,E2) or =average(C2:E2). The first case is used if the cells are not continuous whereas the second case is used when the cells are continos.

### 1. The AVERAGE Function

• Function Objective:

The AVERAGE function calculates the average of numbers in a range of cells.

• Syntax:

AVERAGE(number1, [number2], …)

• Arguments Explanation:
• Return Parameter:

The average of all the numbers in a range of cells.