# 40+ Excel Mathematical Formulas List PDF

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

### Microsoft Excel Step By Step Maths Functions

#### Simple arithmetic

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 the = sign followed by the operation on cells
4. The cell number represents the numbers (For example 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 (number 1, number 2, number, 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 the 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 continuous.

#### 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.