Logical Functions of Ms Excel ?

                                         Previously in a blog post I noted down the key Mathematical Functions of Ms Excel. For whom, it wasn't seen by, read it here.

Logical Functions in Ms Excel will be familiar for those who already learned some programming. But, for them & others syntax of this Ms Excel exampled in here will sure be important as well as worth reading.

Logical Functions will be explained with proper examples as well as images that will be helpful to you.

1. AND - Returns true if all the arguments are true & returns false if any argument is false.

In the above example, A1>=20 & B1=34 & C1<=50 are true. So, as all of the arguments are true the result should be 'TRUE'.

Look at the following example. A1>=20 is the only argument which is true but the result is 'FALSE', as the other two arguments are false. (<> not equal)

2. OR - Returns true if any argument is true & returns false if all arguments are false.

In the above example, A1>20 is the only argument which is true. Both, B1<>(not equal)34,C1<>42 are false. But, the result should be 'TRUE'.

Look at the example below, all the arguments are false here.

The result is false. Having all argument false makes the OR function to return false.

3. NOT - Returns the reverse of the true of false state of an argument. Look at the example below. The A1<>21 is false.

But, ironically it returns true. That's because of the intervention of =NOT() function.

In the following Example A1=21 is true.

Instead of returning the actual state, It returns false.

4. If - returns the value which is set as arguments, when the logical test provided (also as an argument) is true or false.

In the Example, the provided logical test is correct & the function returns "Correct" which is set by us. You can your provide your own value here.

That's it for this Post! Hope You Enjoy Ms Excel Logical Functions.

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!