- Home
- Math Functions In Excel

# Math Functions In Excel

**Math Functions in Excel**

**1. SUM (): -**Numbers are added by this function. In this, the value, cell address or cell range can be given.Example:- =SUM(a1:a4)result:- 180

**2. SQRT (): - With**the help of this function any number of SQUARE ROOT is extracted. In its argument, give the cell address of a number or give that number. Whose SQUARE ROOT is to be extracted.Example:- =SQRT(25)

**3. odd (): - With**this function even number can be converted to odd number.

Example = odd (80)

Result = 81

**4. even (): - By this**function odd number can be converted into even number.

Example: - = even (79)

Result = 80

**5. MOD (): - With**the help of this function, the remainder of any number is derived. Two arguments are given in it.

Example: - = MOD (26,5)

result = 1

**6.POWER (): -**The power of any number can be calculated from this function. Two arguments are given in this, first number, second power.

Example: - = POWER (5,2)

Result = 25

**7. ABS (): -**derives absolute value from it. That is, if there is any sign. Then it is removed. It takes a number in the argument.Example:- =abs (-125)

Result = 125

**8.Fact (): - With**the help of this function, the Factorial number of any number can be extracted. It takes a number in the argument.

Like, there is a Factorial of 5. 1 * 2 * 3 * 4 * 5 = 120Example:- =fact (5)

Result= 120

**9. INT (): -**Can extract the integer value of any number from this function. It takes a number in the argument.Example:- =int(123.34)

Result=123