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)