Microsoft Excel Mathematical Functions ?

There're four types of functions that can be used in Microsoft Excel.

• Mathematical Functions
• Logical Functions
• Statistical Functions
• Date & Time Functions

Let's Start with some explanation about the way to type in your Microsoft Excel functions. First, select the cell & type your function in the Formula Bar below the Ribbon.

Alright, Let's start discussing about functions.

1. Mathematical Functions

• SUM - [=SUM(number1,number2,.....)] 

You've to include cell addresses inside the brackets with 'comma' as the separating symbol or sometimes you can enter a range of cells like in the following scenario.

• PRODUCT - [=PRODUCT(number1,number2,....)]

You've to include cell address inside the brackets like the above mathematical function which is a SUM.

 

 

• FACT - [=FACT(number)]

For those who know what Factorial in mathematics this functions would be helpful & understandable in the first place. You've to enter a cell number inside the brackets.

 

 

• POWER - [=POWER(number1,number2,....)]

Similar to above functions you've got to enter a cell address or a static numerical value inside the brackets. Gives the x power of y number.

 

• SQRT - [=SQRT(number)]

 

• MOD - [=MOD(Number, Divisor)]

 Returns the remainder after a number is divided by a divisor.

 

 

=MOD(49,7) = 0

• INT - [=INT(number)]

Rounds the number to the nearest integer.

=INT(34.4323) = 34

• ROUND - [=ROUND(number, number of digits)]

Rounds a number to a specified number of digits.

=ROUND(25.1213,3) =25.121

• QUOTIENT - [=QUOTIENT(numerator, denominator)]

 

 

Returns the integer portion of a division. Use this function when you want to discard the remainder of a division.

• SUMPRODUCT - [=SUMPRODUCT(array1,array2)]

= (49*3)+(1*2)=149

• SUMIF - [=SUMIF(range, criteria,sum_range)]

Adds the cell specified by given criteria.

=SUMIF(A2:D2,"S",A1:D1) = 4


You can catch all these functions and more in the formula tab of the ribbon Math & Trig Drop down. Try to study forward & Enjoy!