Basic math functions: power, product, quotient, mod, sum
Excel Function POWER
The POWER() function returns the result of a specified number raised to a given power.
This function takes two arguments; number and power.
The POWER() function is tantamount to using the symbol ^.
This function can be used with any kind of numbers.
The Syntax is POWER(number, power)
Number | Power | POWER() | Formula |
2 | 2 | 4 | =POWER(L4,M4) |
3 | -2.4 | 7.15993349974727E-02 | =POWER(L5,M5) |
5.2 | 0 | 1 | =POWER(L6,M6) |
6.012 | 4 | 1306.39914549274 | =POWER(L7,M7) |
-2 | -3 | -0.125 | =POWER(L8,M8) |
Excel Function PRODUCT
The PRODUCT() function returns the product of any number of given numbers.
This function multiplies all the numbers specified within.
The maximum numbers that can be multiplied at present is limited to 255.
The Syntax is : PRODUCT(num1,num2,�..num255)
PRODUCT() | Remarks | Formula |
180 | 3 args | =PRODUCT(2,3,5,6) |
-25.2 | decimal args | =PRODUCT(2.1,-1,2,6) |
32527440 | long integer | =PRODUCT(2,44,555,666) |
-0.00098 | negative numbers | =PRODUCT(0.01,-0.098) |
#NAME? | contains alphabet | =PRODUCT(1,2,3,a) |
0 | contains 0 | =PRODUCT(1,2,45,0) |
Excel Function QUOTIENT
The QUOTIENT() function is used to determine the quotient of two numbers.
This function takes only two arguments and must be numerical value only.
The two arguments are numerator and denominator.
A denominator of 0 results in error.
The Syntax is : QUOTIENT(numerator, denominator)
Numerator | Denominator | QUOTIENT() | Formula |
3 | 2 | 1 | =QUOTIENT(L32,M32) |
4 | 67 | 0 | =QUOTIENT(L33,M33) |
41 | -20 | -2 | =QUOTIENT(L34,M34) |
-9.08 | 0 | #DIV/0! | =QUOTIENT(L35,M35) |
-0.002 | 2 | 0 | =QUOTIENT(L36,M36) |
11 | 0.9 | 12 | =QUOTIENT(L37,M37) |
It should be noted that the quotient actually returns a real number with the decimal part omitted.
Excel Function MOD
The MOD() function returns the remainder of a division operation.
This function takes two arguments; number and divisor.
This function also returns a real number without any decimal part.
This function too results in error if divided by 0.
The Syntax is MOD(number,divisor)
Numerator | Denominator | MOD() | Formula |
3 | 2 | 1 | =MOD(L48,M48) |
4 | 67 | 4 | =MOD(L49,M49) |
41 | -20 | -19 | =MOD(L50,M50) |
-9.08 | 0 | #DIV/0! | =MOD(L51,M51) |
-0.002 | 2 | 1.998 | =MOD(L52,M52) |
11 | 0.9 | 0.2 | =MOD(L53,M53) |
Excel Function SUM
The SUM() function returns the sum of all numbers specified within the function.
The SUM() function can take a maximum of 255 numbers of any type except complex numbers.
This function can either take individual number arguments or a range which contains the numbers.
The Syntax is SUM(num1,num2,...) or SUM(range).
SUM() | Remarks | Formula |
16 | 3 args | =SUM(2,3,5,6) |
9.1 | decimal args | =SUM(2.1,-1,2,6) |
1267 | long integer | =SUM(2,44,555,666) |
-0.088 | negative numbers | =SUM(0.01,-0.098) |
5 | short integer | =SUM(1,2,3,-1) |
1297.012 | Sum of L63:L67 | =SUM(L63:L67) |