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
Example = odd (80)
Result = 81
4. even (): - By this function odd number can be converted into even number.
Example: - = even (79)
Result = 80
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
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
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
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 = 120
Like, there is a Factorial of 5. 1 * 2 * 3 * 4 * 5 = 120
Example:- =fact (5)
Result= 120
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
Result=123
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
ConversionConversion EmoticonEmoticon