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)

 

You can find similar Excel Questions and Answer hereunder

1) basic math functions round rounddown roundup sign

2) basic math functions degrees radians rand

3) basic math functions seriessum sumsq sumx2my2 sumx2py2 sumxmy2 subtotal

4) basic math functions log log10 roman trunc

5) What is the design mode in the developer Tab in Excel

6) statistical functions maxa median mina mode normdist norminv

7) basic math functions abs even odd iseven isodd

8) basic math functions gcd lcm mround multinomial sqrt sqrtpi

9) basic math functions asin acos atan acot

10) How can I calculate depreciation of assets using Excel?

 

Here the previous and next chapter