2. mathematical functions in excel

2. Mathematical Functions in Excel

1. Mathematical Functions -Excel
2013

2. Introduction
•A very important feature in Excel is the formula. It is used to
calculate values based on what is in cells, perform operations on a
cell content, fetch values after an operation based on your search
criteria and much more.
•Mathematical Formulas in Excel are used to perform various
arithmetic operations like sum, average, count, max, min etc. Here
is a list of most frequently used mathematical formulas in excel.
•SUM():
•This function is used to adds all the values within a cell range.
•Syntax:
•sum(cell address : cell address) Example:sum(C1:C3)=15
•Here in the example below, we will create a basic function to
calculate thesum of working hours generates in a day.

4. Selectthecellwhereyouwanttoputtheformula,typetheequalssign(=)andwrite
thedesiredfunctionnameorchoosethefunctionfromthesuggestedfunctionlist.
HereintheexamplebelowwewritetheSUMfunction.

5. Now write the range of sum or you can select the range by using the mouse to drag.

6. Now press Enter key to see the result or press Ctrl+Enterkey to stay in the
formula cell. Here is the picture below.

7. You can use the sum() function in other ways. Here is the syntax.
sum(number1,number2,number3....)
Example: sum(4,5,6)=15

8. SUMIF():
Here in the example below, we will create a basic function to calculate
thesum of working hours generates in a day only for female employees.

9. Syntax:
SUMIF( range,criteria) Type the equals sign and write the desired function in the cell
E14. Here is the picture below.

10. Press Enter to see the result and move the cell pointer to below cell or press
Ctrl+Enterto stay on the cell.

11. AVERAGE():
Here in the example below, we will create a basic function to calculate theaverage
working hours of each employee.

12. Press Enter key and see the result.
You can use the AVERAGEIF() and AVERAGEIFS() function in a similar way as SUMIF()
function, to average cells based on one or multiple criteria.

13. COUNT()
Here in the example below, we will create a basic function to calculate thenumber of
employees.

14. ROUND():
The round function is used to round a number to a specified number of digits.
Syntax:
ROUND(number, number_of_digits)

15. RAND():
This function is used to returns a random number greater than or equal to 0 and less
than 1.
Syntax:
RAND()

16. MOD()
This function is used to find the remainder after dividing a number by another
number.
Syntax:
MOD(number,divisor)

17. INT():
This function is used to converts a decimal number to integer lower than it.
Syntax:
INT(decimal number)

18. AVERAGE():
Formula:
This function is used to calculate the average of a range of cells.
Syntax:
AVERAGE(number1,number2,.......)

19. ABS():
The abs() function is used to return the absolute value of a given number. The number
may be positive or negative. Here is the example below.

20. ARABIC():
This function is used to convert roman numeral to arabic. This function accepts roman
numeral as an argument. The picture below shows that you can write the formula in
any cell or you can use the function wizard or you can select any cell and write the
formula in the formula bar and press Ctrl+enterto stay the cell or press enter see the
result.

21. CEILING.MATH():
Thisfunctionisusedtoroundsanumberuptothenearestintegerortothenearestmultiple
significance.Thisfunctionacceptsthreearguments,thesearenumber,significanceandmode.
Numberisanumber,significanceisthemultipletowhichyouwanttoroundandmodeisalsoa
number.Hereintheexamplebelowthenumberis6.423andthesignificanceis3andthenearest
multipleof3ofthegivennumberis9andthemodeisanonzero,sothisfunctionstartsrounding
away from zero.

22. Thank You